SYSTEM CATALOGS / SYSTEM CATALOGS
pg_propgraph_element
Read PG 19 beta 3 manual ↗The catalog pg_propgraph_element stores information about the vertices and edges of a property graph, collectively called the elements of the property graph.
Pre-release documentation. These definitions may change before the final release.
- Kind
- System catalogs
- Columns in this snapshot
- 14
- Definition source
- English manual
Columns 14
| Column | Type | Description / reference |
|---|---|---|
oid | oid | Row identifier |
pgepgid | oid | Reference to the property graph that this element belongs to pg_class.oid |
pgerelid | oid | Reference to the table that contains the data for this property graph element pg_class.oid |
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 | For an edge, a link to the source vertex. (Zero for a vertex.) |
pgedestvertexid | oid | For an edge, a link to the destination vertex. (Zero for a vertex.) |
pgekey | int2[] | 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.) pg_attribute.attnum |
pgesrckey | int2[] | 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. pg_attribute.attnum |
pgesrcref | int2[] | 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. pg_attribute.attnum |
pgesrceqop | oid[] | For an edge, an array of equality operators for pgesrcref = pgesrckey comparison. (Null for a vertex.) pg_operator.oid |
pgedestkey | int2[] | 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. pg_attribute.attnum |
pgedestref | int2[] | 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. pg_attribute.attnum |
pgedesteqop | oid[] | For an edge, an array of equality operators for pgedestref = pgedestkey comparison. (Null for a vertex.) pg_operator.oid |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
oid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgepgid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgerelid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgealias | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgekind | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgesrcvertexid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgedestvertexid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgekey | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgesrckey | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgesrcref | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgesrceqop | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgedestkey | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgedestref | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
pgedesteqop | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | · |
Version history 2
- PG 19 → 20removed
- PG 18 → 19added
Definition snapshot: english-manuals:f1be1edcb75adc7322b99d32d6f… · English manual source