/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 vote121 views1 answer
Where case insensitive like mysql
SQL
0 vote134 views1 answer
Like date sql server not working
SQL
1 vote136 views1 answer
Oracle grant on all tables in schema
SQL
0 vote144 views1 answer
Replace string in whole database mysql stackoverflow
SQL
1 vote144 views2 answers
Mysql SELECT
SQL
3 votes128 views4 answers
Show sql server database
SQL
1 vote117 views1 answer
Sql Split string function
SQL
1 vote142 views1 answer
Full sql mode
SQL
-1 vote136 views2 answers
Import data from excel to sql server automatically
SQL
0 vote128 views1 answer
View t-sql mail configuration
SQL