Skip to content

`pg_propgraph_property`

pg_propgraph_property

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.

Table: pg_propgraph_property Columns

Column Type

Description

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.)