修改表所属模式

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

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

postgres=# alter table t set schema public;
ALTER TABLE

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