/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 vote323 views1 answer
Psql check if sql script is valid
SQL
1 vote271 views2 answers
Setval max id postgresql sequence
SQL
0 vote296 views1 answer
Full outer join in mariadb mysql
SQL
-1 vote271 views3 answers
Psql get last rows
SQL
0 vote294 views1 answer
How to run mysql in git bash
SQL
7 votes283 views1 answer
Sql limit decimal places
SQL
0 vote287 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote304 views1 answer
Reset postgres table index to next max value
SQL
0 vote302 views1 answer
Select milliseconds mysql
SQL
2 votes259 views1 answer
Mysql list users on ubuntu
SQL