/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 vote194 views1 answer
Mysql jdbc timezone
SQL
0 vote202 views1 answer
Extract sql from query object sqlalchemy
SQL
4 votes229 views3 answers
Sql find second highest salary employee
SQL
0 vote219 views1 answer
Sql injection payload list github
SQL
2 votes206 views1 answer
Possgress drop if exists table
SQL
1 vote198 views1 answer
Update and replace mysql
SQL
5 votes183 views1 answer
List foreign key oracle
SQL
0 vote230 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote219 views1 answer
SQL Server date literal
SQL
0 vote203 views1 answer
Como hacer un select entre fechas mysql
SQL