/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

3 votes184 views1 answer
Postgresql db owner change
SQL
0 vote212 views1 answer
Sql server create constraint
SQL
2 votes186 views2 answers
Sql first character
SQL
1 vote169 views4 answers
Sql now
SQL
0 vote290 views1 answer
Mysql grant access to one database
SQL
5 votes175 views1 answer
Sql select ciunt
SQL
0 vote188 views1 answer
Change magento database url usimg musql
SQL
0 vote184 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote184 views1 answer
Sql list dates between two dates
SQL
0 vote185 views1 answer
Mysql uuid
SQL