xtdb icon indicating copy to clipboard operation
xtdb copied to clipboard

psql `\d <table>` support

Open refset opened this issue 1 month ago • 0 comments

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>, ';'}"}

refset avatar Dec 04 '25 12:12 refset