/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 vote199 views1 answer
Mysql preg replace
SQL
7 votes172 views1 answer
Set sequence value oracle
SQL
1 vote176 views4 answers
Mysqldump 1 table only
SQL
16 votes167 views2 answers
Mysql date between two dates
SQL
2 votes166 views1 answer
Alter table add multiple columns postgresql
SQL
3 votes189 views1 answer
Mysql replace string in table
SQL
2 votes194 views2 answers
Calculate percentage in sql
SQL
1 vote170 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
1 vote165 views2 answers
ImportError: No module named mysql.connector
SQL
5 votes175 views1 answer
Sort order on two columns sql
SQL