select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / SYSTEM INFORMATION FUNCTIONS AND OPERATORS

pg_index_column_has_property

Read PG 18 manual ↗

Tests whether an index column has the named property.

Signatures & examples

pg_index_column_has_property ( index regclass, column integer, property text ) → boolean
Tests whether an index column has the named property. Common index column properties are listed in Table 9.77. (Note that extension access methods can define additional property names for their indexes.) NULL is returned if the property name is not known or does not apply to the particular object, or if the OID or column number does not identify a valid object.
Version history 8
  1. PG 18 → 19changed
  2. PG 17 → 18changed
  3. PG 16 → 17changed
  4. PG 15 → 16changed
  5. PG 14 → 15changed
  6. PG 13 → 14changed
  7. PG 12 → 13changed
  8. PG 9.5 → 9.6added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source