cwida / duckpgq-extension

DuckDB extension that adds support for SQL/PGQ
https://duckpgq.notion.site/b8ac652667964f958bfada1c3e53f1bb?v=3b47a8d44bdf4e0c8b503bf23f1b76f2
MIT License
86 stars 7 forks source link

Describe property graph #114

Closed Dtenwolde closed 7 months ago

Dtenwolde commented 8 months ago

There is currently no way to describe a created property graph except by returning to the original query used to create it. A nice-to-have would be to describe property graph <pg_name> and output the vertex and edge tables. The output could be something along the lines of:

describe property graph <pg_name>
----
| table_name | label | vertex_table | source pk | source fk | destination pk | destination fk |
| -------------------------------------------------------------------------------------- |
| features | features | YES | NULL | NULL | NULL | NULL |
| edges | edges | NO | follower | numeric_id | followed | numeric_id | (The source and destination table should also be included)
--------------------------------------------------------------------