Skip to content

`pg_element_tables`

pg_element_tables

The view pg_element_tables contains information about 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).

Table: pg_element_tables 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)

element_table_kind character_data

The kind of the element table: EDGE or VERTEX

table_catalog sql_identifier

Name of the database that contains the referenced table (always the current database)

table_schema sql_identifier

Name of the schema that contains the referenced table

table_name sql_identifier

Name of the table being referenced by the element table definition

element_table_definition character_data

Applies to a feature not available in PostgreSQL