/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 vote378 views1 answer
Error code 1451 sql
SQL
3 votes329 views1 answer
Oracle apex warning message
SQL
0 vote362 views1 answer
How to join result table in mysql
SQL
6 votes327 views2 answers
WHERE value IS sql
SQL
0 vote329 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote310 views1 answer
Downgrading sql localdb visual studio
SQL
2 votes321 views1 answer
Docker run postgres locally
SQL
0 vote362 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
1 vote342 views1 answer
Tsql create unique index composite
SQL
2 votes345 views1 answer
Sql update from different table
SQL