xtdb
xtdb copied to clipboard
psql `\d <table>` support
Currently \d works but \d <table> throws an error due to a lack of support for OPERATOR/COLLATE (at least):
xtdb=> \d product
ERROR: Errors parsing SQL statement:
- line 6:16 mismatched input 'OPERATOR' expecting {<EOF>, ';'}
DETAIL: {"code":"xtdb\/sql-error","category":"cognitect.anomalies\/incorrect","sql":"SELECT c.oid,\n n.nspname,\n c.relname\nFROM pg_catalog.pg_class c\n LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace\nWHERE c.relname OPERATOR(pg_catalog.~) '^(product)$' COLLATE pg_catalog.default\n AND pg_catalog.pg_table_is_visible(c.oid)\nORDER BY 2, 3;","message":"Errors parsing SQL statement:\n - line 6:16 mismatched input 'OPERATOR' expecting {<EOF>, ';'}"}