/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

3 votes329 views2 answers
Mysql create database
SQL
16 votes335 views4 answers
Sort by sql
SQL
5 votes330 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote361 views1 answer
.sql File Run in PSQL
SQL
22 votes339 views3 answers
Remove all records from table mysql
SQL
0 vote339 views1 answer
Sql server convert to guid
SQL
4 votes330 views2 answers
Oracle last day of month
SQL
0 vote323 views1 answer
Sql grant select only
SQL
21 votes314 views6 answers
Docker run mysql
SQL
0 vote318 views1 answer
Sum sqlserver
SQL