/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

3 votes301 views1 answer
Unsigned int in mysql
SQL
0 vote280 views1 answer
Casterar postgres
SQL
0 vote290 views1 answer
Android sqlite add column if not exists
SQL
8 votes299 views3 answers
Alter user root mysql
SQL
1 vote268 views1 answer
Sql week commencing date
SQL
0 vote285 views2 answers
Sql join on comma separated field
SQL
6 votes312 views3 answers
How to delete table sqlite
SQL
0 vote311 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
2 votes296 views1 answer
Sql OR
SQL
0 vote297 views2 answers
How to get the date from datetime in mysql
SQL