/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

1 vote181 views1 answer
Clear screen command in psql
SQL
-1 vote166 views2 answers
On delete set default sql server
SQL
0 vote211 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote198 views1 answer
How to to get current date in sql
SQL
0 vote185 views1 answer
Mysql find db contarint
SQL
1 vote185 views1 answer
Oracle duration between timestamps
SQL
0 vote229 views10 answers
Sql statement checker corrector
SQL
0 vote181 views1 answer
Min mysql
SQL
0 vote191 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote199 views1 answer
Postgresql certain first 4 characters in string
SQL