/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 vote355 views2 answers
One to one and one to many relationship
SQL
4 votes327 views3 answers
Copy table postgres
SQL
-1 vote330 views1 answer
Mysql case when multiple conditions
SQL
0 vote333 views1 answer
Inserting data into different tables at once in oracle sql
SQL
7 votes338 views1 answer
Sql server management studio turn on line numbers
SQL
3 votes373 views1 answer
Oracle undo tablespace schema
SQL
1 vote315 views1 answer
Mysql get character set
SQL
1 vote326 views1 answer
Get parameter value in mysql trigger
SQL
1 vote321 views1 answer
Oracle create index if not exists
SQL
0 vote319 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL