Functions / System Information Functions And Operators

pg_get_indexdef

Reconstructs the creating command for an index.

Reading PG 18current·documented in 26 of 27 versions, 7.2 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

pg_get_indexdef ( index oid [, column integer, pretty boolean ] ) → text

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.

Version history 4

12 → 13 changed
7.4 → 8.0 changed
7.3 → 7.4 changed
7.1 → 7.2 added

Definition snapshot: b7bd9cda · English manual source