pg_propgraph_property — PostgreSQL system catalog

The PostgreSQL pg_propgraph_property system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  2 min read

Summary

The catalog pg_propgraph_property stores information about the properties in a property graph. This only stores information that applies to a property throughout the graph, independent of what label or element it is on. Additional information, including the actual expressions that define the properties are in the catalog pg_propgraph_label_property.

(Description quoted from the official PostgreSQL documentation.)

Columns

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

  • oid oid
    Row identifier
  • pgppgid oid references pg_class.oid
    Reference to the property graph that this property belongs to
  • pgpname name
    The name of the property. This is unique among the properties in a graph.
  • pgptypid oid references pg_type.oid
    The data type of this property. (This is required to be fixed for a given property in a property graph, even if the property is defined multiple times in different elements and labels.)
  • pgptypmod int4
    typmod to be applied to the data type of this property. (This is required to be fixed for a given property in a property graph, even if the property is defined multiple times in different elements and labels.)
  • pgpcollation oid references pg_collation.oid
    The defined collation of this property, or zero if the property is not of a collatable data type. (This is required to be fixed for a given property in a property graph, even if the property is defined multiple times in different elements and labels.)

Related catalogs

This object references the following other system catalogs:

Version applicability

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

Related & references

Reference: PostgreSQL documentation — pg_propgraph_property.