/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 vote138 views1 answer
Mysql update privileges
SQL
0 vote135 views1 answer
Initcap in mysql
SQL
1 vote148 views1 answer
T-sql disable system versioning
SQL
5 votes139 views1 answer
Mysql where one year ago
SQL
0 vote101 views2 answers
Sql update from two different database
SQL
0 vote218 views3 answers
Osx stop mysql service
SQL
7 votes259 views2 answers
Drop index oracle
SQL
0 vote128 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
10 votes130 views4 answers
Drop primary key
SQL
0 vote155 views1 answer
Sql tablo sp
SQL