/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 vote224 views1 answer
TSQL function split string
SQL
0 vote194 views1 answer
Group by sql not ordering issues
SQL
0 vote197 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote293 views1 answer
Example database query
SQL
1 vote282 views3 answers
Showing all columns in an sqlite table
SQL
2 votes213 views1 answer
Install postgresql centos 5
SQL
0 vote221 views1 answer
Query to insert image
SQL
0 vote176 views1 answer
Trim sql oracle
SQL
1 vote208 views1 answer
Nullif postgresql
SQL
1 vote269 views2 answers
Intersect sql
SQL