修改表所属用户

最近更新时间: 2025-02-18 16:02:00

  • 复制
    复制成功
postgres=# \dt tbase
       List of relations
 Schema | Name  | Type  | Owner 
--------+-------+-------+-------
 public | tbase | table | tbase
(1 row)

postgres=# alter table tbase owner to pgxz;
ALTER TABLE

postgres=# \dt tbase
       List of relations
 Schema | Name  | Type  | Owner 
--------+-------+-------+-------
 public | tbase | table | pgxz
(1 row)