35.35. pg_element_table_key_columns
Prev UpChapter 35. The Information SchemaHome Next

35.35. pg_element_table_key_columns #

The view pg_element_table_key_columns identifies which columns are part of the keys of the element tables of property graphs defined in the current database. Only those property graphs are shown that the current user has access to (by way of being the owner or having some privilege).

The key of an element table uniquely identifies the rows in it. It is either specified using the KEY clause in CREATE PROPERTY GRAPH or defaults to the primary key.

Table 35.33. pg_element_table_key_columns Columns

Column Type

Description

property_graph_catalog sql_identifier

Name of the database that contains the property graph (always the current database)

property_graph_schema sql_identifier

Name of the schema that contains the property graph

property_graph_name sql_identifier

Name of the property graph

element_table_alias sql_identifier

Element table alias (unique identifier of an element table within a property graph)

column_name sql_identifier

Name of the column that is part of the key

ordinal_position cardinal_number

Ordinal position of the column within the key (count starts at 1)


Prev Up Next
35.34. pg_edge_table_components Home 35.36. pg_element_table_labels