Reconstructs the creating command for an index. (This is a decompiled reconstruction, not the original text of the command.) If column is supplied and is not zero, only the definition of that column is reconstructed.
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
column is supplied and is not zero, only the definition of that column is reconstructed.pg_get_indexdef ( index oid [, column integer, pretty boolean] ) → text → textReconstructs the creating command for an index. (This is a decompiled reconstruction, not the original text of the command.) If
column is supplied and is not zero, only the definition of that column is reconstructed.{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:17398cd1307d453c218fde5e585ba2d0276d6af8661632f81bcbd2a0edc0cca7
Text language: en · wiki-repair-20261023:17398cd1307d453c218fde5e585ba2d0276d6af8661632f81bcbd2a0edc0cca7