Version:

This documentation is sourced from a third-party project and is not maintained by pgEdge.

`pg_propgraph_element`

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

Table: pg_propgraph_element Columns

Column Type

Description

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