/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

-1 vote154 views1 answer
MYSQL stored procedure select from
SQL
0 vote147 views1 answer
Drop column from local database postgres pgadmin
SQL
12 votes146 views1 answer
Docker run mysql image
SQL
0 vote203 views1 answer
ORA-01400
SQL
0 vote124 views1 answer
How to create an SQL save method in ruby
SQL
1 vote155 views2 answers
Sql where is not number
SQL
3 votes140 views1 answer
Create a table with an id in mysql
SQL
8 votes182 views2 answers
Default sql server port
SQL
0 vote142 views1 answer
Mysql date time string format python
SQL
1 vote143 views1 answer
Timestamp in sqlite
SQL