/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

41 votes167 views6 answers
Alter table add column in SQL Server
SQL
1 vote103 views1 answer
Mysql view current queries
SQL
24 votes112 views6 answers
Replace mysql
SQL
0 vote107 views1 answer
Update top 100 order by sql server
SQL
0 vote118 views1 answer
Install package for sqlserver in asp.net core
SQL
2 votes104 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
4 votes107 views4 answers
Oracle tablespace tables list
SQL
1 vote100 views1 answer
Create new table in SQL from old table with data
SQL
0 vote114 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote95 views1 answer
Create function syntax sql server
SQL