↑↓ 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_has_property

Read the PG 18 manual

Tests whether an index has the named property.

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

Signatures & examples

pg_index_has_property ( index regclass, property text ) → boolean
Tests whether an index has the named property. Common index properties are listed in Table 9.78. (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 does not identify a valid object.
Version history 8
  1. 18 → 19 changed
  2. 17 → 18 changed
  3. 16 → 17 changed
  4. 15 → 16 changed
  5. 14 → 15 changed
  6. 13 → 14 changed
  7. 12 → 13 changed
  8. 9.5 → 9.6 added

Definition snapshot: b7bd9cda · English manual source