將表移出回收站
更新時間 2025-02-05 09:37:14
最近更新時間: 2025-02-05 09:37:14
分享文章
本頁為您介紹如何將表移出回收站。
ALTER TABLE trash._1 RENAME to t;
ALTER TABLE trash.t SET SCHEMA public;
\dt public.*
List of relations
Schema | Name | Type | Owner
--------+------+-------+----------
public | t | table | teledb
(1 row)
\dt "trash".*
List of relations
Schema | Name | Type | Owner
--------+-------------+-------+----------
trash | _2 | table | teledb
trash | trash_table | table | teledb
(2 rows)
