重庆思庄Oracle、Redhat认证学习论坛

标题: 如何查看TOAST表的扩展表 [打印本页]

作者: 郑全 时间: 2024-5-3 09:47
标题: 如何查看TOAST表的扩展表
比如建立了一个TOAST表:TOAST_T1，想找他的扩展表，可以通过以下方式找到扩展表：

select relname,reltoastrelid::regclass
  from pg_class
where relname='toast_t1';
relname  |    reltoastrelid
----------+-------------------------
toast_t1 | pg_toast.pg_toast_17623
(1 row)

zlcost=# \d+ pg_toast.pg_toast_17623
TOAST table "pg_toast.pg_toast_17623"
Column |  Type | Storage
------------+---------+---------
chunk_id | oid    | plain
chunk_seq  | integer | plain
chunk_data | bytea | plain
Owning table: "sztech.toast_t1"
Indexes:
"pg_toast_17623_index" PRIMARY KEY, btree (chunk_id, chunk_seq)
Access method: heap

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)