SELECT ‘ALTER TABLE ‘ || schemaname || ‘.’ || tablename || ‘ OWNER TO new_user;’ FROM pg_tables WHERE tableowner =‘old_user’
[DB]postgres のテーブル所有者一括変更

SELECT ‘ALTER TABLE ‘ || schemaname || ‘.’ || tablename || ‘ OWNER TO new_user;’ FROM pg_tables WHERE tableowner =‘old_user’
コメント