/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 vote311 views1 answer
Sql delete where x or y or z
SQL
2 votes381 views3 answers
Mysql unix timestamp to date
SQL
0 vote313 views1 answer
Mysql search multiple tables
SQL
9 votes329 views6 answers
Replace sql
SQL
0 vote323 views1 answer
Exectuer myssql .sql
SQL
0 vote306 views1 answer
Codeigniter dbforge add index
SQL
0 vote340 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote310 views1 answer
Complete date is 1 year or not sql server
SQL
4 votes349 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
6 votes303 views2 answers
Mysql first day of month
SQL