/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 vote272 views1 answer
Sequelize postgresql schema
SQL
2 votes279 views2 answers
Get all tables using like
SQL
1 vote260 views3 answers
Default password of mysql
SQL
13 votes299 views4 answers
Mysql remove foreign key constraint
SQL
0 vote278 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote251 views1 answer
Postgres add prefix to primary key
SQL
0 vote268 views1 answer
How to check even or odd in sql
SQL
2 votes229 views2 answers
Mysql get last character of string
SQL
16 votes311 views3 answers
Get count of duplicate records
SQL
7 votes348 views2 answers
3rd height salary sql
SQL