pg_propgraph_element — PostgreSQL system catalog

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

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

Summary

The catalog pg_propgraph_element stores information about the vertices and edges of a property graph, collectively called the elements of the property graph.

(Description quoted from the official PostgreSQL documentation.)

Columns

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

  • oid oid
    Row identifier
  • pgepgid oid references pg_class.oid
    Reference to the property graph that this element belongs to
  • pgerelid oid references pg_class.oid
    Reference to the table that contains the data for this property graph element
  • pgealias name
    The alias of the element. This is a unique identifier for the element within the graph. It is set when the property graph is defined and defaults to the name of the underlying element table.
  • pgekind char
    v for a vertex, e for an edge
  • pgesrcvertexid oid references pg_propgraph_element.oid
    For an edge, a link to the source vertex. (Zero for a vertex.)
  • pgedestvertexid oid references pg_propgraph_element.oid
    For an edge, a link to the destination vertex. (Zero for a vertex.)
  • pgekey int2[] references pg_attribute.attnum
    An array of column numbers in the table referenced by pgerelid that defines the key to use for this element table. (This defaults to the primary key when the property graph is created.)
  • pgesrckey int2[] references pg_attribute.attnum
    For an edge, an array of column numbers in the table referenced by pgerelid that defines the source key to use for this element table. (Null for a vertex.) The combination of pgesrckey and pgesrcref creates the link between the edge and the source vertex.
  • pgesrcref int2[] references pg_attribute.attnum
    For an edge, an array of column numbers in the table reached via pgesrcvertexid. (Null for a vertex.) The combination of pgesrckey and pgesrcref creates the link between the edge and the source vertex.
  • pgesrceqop oid[] references pg_operator.oid
    For an edge, an array of equality operators for pgesrcref = pgesrckey comparison. (Null for a vertex.)
  • pgedestkey int2[] references pg_attribute.attnum
    For an edge, an array of column numbers in the table referenced by pgerelid that defines the destination key to use for this element table. (Null for a vertex.) The combination of pgedestkey and pgedestref creates the link between the edge and the destination vertex.
  • pgedestref int2[] references pg_attribute.attnum
    For an edge, an array of column numbers in the table reached via pgedestvertexid. (Null for a vertex.) The combination of pgedestkey and pgedestref creates the link between the edge and the destination vertex.
  • pgedesteqop oid[] references pg_operator.oid
    For an edge, an array of equality operators for pgedestref = pgedestkey comparison. (Null for a vertex.)

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