pg 修改表的所有者

1. 单表修改所有者
   alter table 表名 owner to baobao;

2. 多表修改所有者
   先执行以下语句, 然后将结果copy出来再执行一遍

SELECT 
 'alter table 模式.' || relname || ' owner to baobao;' 
 FROM
 pg_class  
 WHERE
 relname IN ( SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg%' AND tablename NOT LIKE 'sql_%' ) 

3. 单序列修改所有者
   alter SEQUENCE 序列名 owner to baobao;

4. 多序列修改所有者

SELECT
'alter SEQUENCE 模式.' || relname || ' owner to baobao;' 
FROM
pg_class 
WHERE
relname IN ( SELECT relname FROM pg_class WHERE relkind = 'S' );