/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 vote232 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
1 vote273 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote224 views1 answer
Oracle enable chain
SQL
0 vote247 views1 answer
Sql declare variable single line
SQL
0 vote240 views2 answers
Sqlite unix timestamp
SQL
6 votes251 views2 answers
Postgresql restore from dump
SQL
16 votes264 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote235 views1 answer
Order by oracle
SQL
0 vote193 views1 answer
Online sql compiler
SQL
0 vote235 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL