35.34. pg_edge_table_components
Prev UpChapter 35. The Information SchemaHome Next

35.34. pg_edge_table_components #

The view pg_edge_table_components identifies which columns are part of the source or destination vertex keys, as well as their corresponding columns in the vertex tables being linked to, in the edge 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 source and destination vertex links of edge tables are specified in CREATE PROPERTY GRAPH and default to foreign keys in certain cases.

Table 35.32. pg_edge_table_components 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

edge_table_alias sql_identifier

The element table alias of the edge table being described

vertex_table_alias sql_identifier

The element table alias of the source or destination vertex table being linked to

edge_end character_data

Either SOURCE or DESTINATION; specifies which edge link is being described.

edge_table_column_name sql_identifier

Name of the column that is part of the source or destination vertex key in this edge table

vertex_table_column_name sql_identifier

Name of the column that is part of the key in the source or destination vertex table being linked to

ordinal_position cardinal_number

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


Prev Up Next
35.33. parameters Home 35.35. pg_element_table_key_columns