/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

2 votes238 views5 answers
SQL trigger
SQL
0 vote262 views1 answer
Sql query wordpress export post
SQL
0 vote241 views1 answer
Report in database
SQL
22 votes216 views6 answers
Create sql table
SQL
6 votes225 views5 answers
Alter table oracle
SQL
0 vote236 views1 answer
Close sql query vb.net
SQL
1 vote231 views3 answers
How to get date in sql
SQL
3 votes275 views1 answer
What is having
SQL
0 vote193 views1 answer
Select mysql limit to 2 decimal places
SQL
1 vote219 views1 answer
Loading local data is disabled mysql
SQL