修改表所属模式

最近更新时间: 2025-10-11 18:10: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)