将带有依赖项表移出回收站
更新时间 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
