PostgreSQL 生成全部的sql修改表owner

PostgreSQL 生成全部的sql修改表owner

SELECT
'alter table ' || nsp.nspname || '.' || cls.relname || ' owner to "newowner";' || chr(13)
FROM pg_catalog.pg_class cls,pg_catalog.pg_namespace nsp
WHERE nsp.nspname IN ('public') AND cls.relnamespace = nsp.oid AND cls.relkind = 'r' 
ORDER BY
nsp.nspname,cls.relname;