/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 vote129 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote186 views1 answer
Java sql insert return id
SQL
0 vote175 views1 answer
Flush user resource mysql
SQL
0 vote178 views1 answer
Empty table sqlite
SQL
0 vote165 views1 answer
Oracle procedure chain step
SQL
-1 vote130 views1 answer
How to create script to connect to oracle database and run query
SQL
1 vote177 views1 answer
Oracle compile schema
SQL
0 vote175 views3 answers
Sql all columns
SQL
0 vote179 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote186 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL