pg_propgraph_label_property — PostgreSQL system catalog

Summary

The catalog pg_propgraph_label_property stores information about the properties in a property graph that are specific to a label. In particular, this stores the expression that defines the property.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_propgraph_label_property system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

• oid oid
  Row identifier
• plppropid oid references pg_propgraph_property.oid
  Reference to the property
• plpellabelid oid references pg_propgraph_element_label.oid
  Reference to the label (indirectly via pg_propgraph_element_label, which then links to pg_propgraph_label)
• plpexpr pg_node_tree
  Expression tree (in nodeToString() representation) for the property’s definition. The expression references the table reached via pg_propgraph_element_label and pg_propgraph_element.

Related catalogs

This object references the following other system catalogs:

• plppropid → pg_propgraph_property
• plpellabelid → pg_propgraph_element_label

Version applicability

Present in PostgreSQL 19 (verified against each release’s documentation). This object was introduced in PostgreSQL 19.

Related & references

• PostgreSQL system catalog & view index
• Built-in function reference

Reference: PostgreSQL documentation — pg_propgraph_label_property.