/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 vote396 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
1 vote343 views1 answer
Sql delete all values in a column
SQL
2 votes405 views1 answer
Oracle insert or update
SQL
0 vote351 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote378 views1 answer
Suhaib
SQL
0 vote407 views1 answer
Mysql, how to query the table comments?
SQL
-1 vote348 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote317 views1 answer
Mysql does collate nopad recognize space
SQL
1 vote379 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote347 views1 answer
Oracle list index on table
SQL