/SQL/Change schema of all tables postgres

Change schema of all tables postgres

DO
$$DECLARE
   p_table regclass;
BEGIN
   SET LOCAL search_path='xyz';
   FOR p_table IN
      SELECT oid FROM pg_class
      WHERE relnamespace = 'xyz'::regnamespace
        AND relkind = 'r'
   LOOP
      EXECUTE format('ALTER TABLE %s SET SCHEMA public', p_table);
   END LOOP;
END;$$;

Source: dba.stackexchange.com

Similar codes

0 vote116 views1 answer
Sql server 2012 create or alter procedure
SQL
7 votes125 views2 answers
Mysql default value
SQL
0 vote125 views2 answers
Mysql missin expression near on
SQL
1 vote139 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote117 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote109 views1 answer
Funzioni plsql
SQL
0 vote116 views1 answer
Sql get user account
SQL
16 votes112 views6 answers
Insert sql
SQL
0 vote115 views1 answer
How to check even or odd in sql
SQL
4 votes127 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL