/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 vote139 views1 answer
Except in sql alchemy
SQL
0 vote121 views1 answer
Postgres data location
SQL
5 votes118 views1 answer
Mysql change primary key
SQL
0 vote81 views1 answer
How to set field to null in sql
SQL
0 vote120 views1 answer
Postgresql stored procedure update table values
SQL
0 vote124 views1 answer
Foreign key type uniqu mysql
SQL
34 votes118 views5 answers
Oracle alter table add column
SQL
1 vote146 views1 answer
Mysql dump specific tables
SQL
0 vote118 views2 answers
Functions with parameters SQL
SQL
5 votes149 views1 answer
Oracle generate list of dates in between a date range
SQL