PostgreSQL更改表的所有者的方法步骤

alter table table_name owner to new_owner;

-- 将表 employees 的所有者改为 user2
alter table employees owner to user2;

-- 使用带模式的完整表名
alter table public.employees owner to user2;

-- 生成更改语句
select 'alter table ' || table_name || ' owner to new_owner;'
from information_schema.tables
where table_schema = 'public'
  and table_type = 'base table';

-- 将 old_user 拥有的所有对象（表、视图、序列等）转给 new_user
reassign owned by old_user to new_user;

-- 查看表的所有者
select 
    tablename, 
    tableowner 
from pg_tables 
where tablename = 'your_table_name';