将表移出回收站
更新时间 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)
