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;$$;