使用超级管理员查询,其中r 是表,S是序列
select case WHEN relkind= ‘r’ then
‘ALTER TABLE ‘||relname||’ owner to resource;’
else
‘ALTER SEQUENCE ‘||relname||’ owner to resource;’
end from pg_class where relkind in (‘r’,‘S’);
使用超级管理员查询,其中r 是表,S是序列
select case WHEN relkind= ‘r’ then
‘ALTER TABLE ‘||relname||’ owner to resource;’
else
‘ALTER SEQUENCE ‘||relname||’ owner to resource;’
end from pg_class where relkind in (‘r’,‘S’);