云数据库 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