/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

6 votes156 views2 answers
Sql query to get the number of rows in a table
SQL
8 votes140 views1 answer
Ltrim sql
SQL
0 vote176 views1 answer
Suhaib
SQL
7 votes144 views3 answers
SQL create a new table
SQL
1 vote197 views1 answer
Connect to mysql database ubuntu
SQL
1 vote152 views1 answer
Sql current timestamp
SQL
0 vote139 views1 answer
Go install mysql
SQL
0 vote178 views2 answers
Search stored procedures by name
SQL
0 vote141 views1 answer
Low level operator in dbms
SQL
0 vote146 views1 answer
Which lock mode is not available in sql
SQL