/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

1 vote168 views1 answer
Sql server update column based on another table
SQL
0 vote148 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote174 views1 answer
Two inner joins sql
SQL
0 vote161 views1 answer
How to generate ids in sql
SQL
0 vote148 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote208 views1 answer
Postgres extract number from string
SQL
12 votes151 views2 answers
Insert multiple rows from another table sql
SQL
1 vote162 views1 answer
Count mysql server db tables
SQL
0 vote190 views1 answer
Sql anywhere create procedure
SQL
0 vote160 views2 answers
Which MySQL statement is used to delete data from a database
SQL