云数据库 GAUSSDB-系统表信息函数:pg_get_indexdef(index_oid)
时间:2025-06-03 09:32:37
pg_get_indexdef(index_oid)
描述:获取索引的CREATE INDEX命令。
返回类型:text
示例:
gaussdb=# SELECT * FROM pg_get_indexdef(16416);
pg_get_indexdef
-------------------------------------------------------------------------
CREATE INDEX test3_b_idx ON test3 USING btree (b) TABLESPACE pg_default
(1 row)
support.huaweicloud.com/distributed-devg-v8-gaussdb/gaussdb-12-2655.html