/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 vote113 views1 answer
Groupby sort sql hive
SQL
0 vote108 views1 answer
Call scalar valued function sql
SQL
1 vote113 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote158 views1 answer
Mysql grant access to one database
SQL
2 votes124 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote157 views1 answer
How to get table current identity value in sql server
SQL
0 vote172 views1 answer
Show mysql account privilleges
SQL
0 vote116 views1 answer
Mysql export and import
SQL
0 vote117 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote125 views1 answer
Order child below the parent in mysqli
SQL