/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 vote259 views1 answer
Select in select sql
SQL
0 vote286 views1 answer
How to generate ids in sql
SQL
2 votes248 views2 answers
Mysql all columns
SQL
1 vote270 views1 answer
Psql search table
SQL
1 vote265 views1 answer
Sql query row number group by
SQL
0 vote239 views1 answer
Linux upload database to mysql
SQL
1 vote283 views1 answer
Update foreign key value in mysql
SQL
3 votes250 views2 answers
Oracle sql truncate table
SQL
1 vote247 views1 answer
Sql group by error
SQL
2 votes287 views3 answers
Mysql kill
SQL