postgresql批量修改表的owner

2.拼接sql

select ‘ALTER TABLE ‘ || table_name || ‘ OWNER TO yourowner;‘ from information_schema.tables where table_schema=‘public‘;

3.报生成的sql 复制下来，执行即可

postgresql批量修改表的owner

标签：format   ring   table   方式   postgres   才有   修改表   row   pass