/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 vote234 views1 answer
Sql server rtrim everything after character
SQL
1 vote220 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
22 votes211 views2 answers
Mysql show all tables
SQL
3 votes211 views3 answers
List columns in table postgres
SQL
0 vote219 views1 answer
Oracle array
SQL
0 vote217 views1 answer
Pl sql round
SQL
0 vote222 views2 answers
Jsonb
SQL
2 votes225 views1 answer
Sql skip the first row
SQL
4 votes224 views2 answers
Oracle unlock user
SQL
1 vote219 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL