/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 vote189 views1 answer
Postgres clear table
SQL
0 vote194 views2 answers
Call to undefined function mysql_query()
SQL
0 vote174 views1 answer
Wordpress sql change site url
SQL
3 votes180 views1 answer
Select sequence oracle
SQL
0 vote165 views1 answer
Uuid sqlalcomany
SQL
0 vote184 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote199 views1 answer
Mysqldump: error:
SQL
0 vote199 views2 answers
Postgres having
SQL
0 vote172 views1 answer
Sql select non unique
SQL
1 vote247 views1 answer
Show databases mysql docker
SQL