將帶有依賴項表移出回收站
更新時間 2025-02-05 09:37:14
最近更新時間: 2025-02-05 09:37:14
分享文章
本頁為您介紹如何將帶有依賴項表移出回收站。
ALTER TABLE trash._5 RENAME to t3;
ALTER TABLE trash.t SET SCHEMA public;
\dt "trash".*
List of relations
Schema | Name | Type | Owner
--------+-------------+-------+----------
trash | _3 | table | teledb
trash | _4 | table | teledb
trash | trash_table | table | teledb
(3 rows)
\d+ t3
Table "t3"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------+---------+-----------+----------+---------+---------+--------------+-------------
id | integer | | not null | | plain | |
Indexes:
"_5.1" btree (id)
Distribute By: SHARD(id)
Location Nodes: ALL DATANODES
