cube icon indicating copy to clipboard operation
cube copied to clipboard

Describing the table in psql returns error

Open maver1ck opened this issue 1 year ago • 1 comments

Describe the bug I'm trying to describe table in psql command line

To Reproduce Steps to reproduce the behavior:

  1. run psql
  2. run
test=> \d dw_fct_xxx;
  1. see error
ERROR:  Unable to parse: ParserError("Expected end of statement, found: OPERATOR")
QUERY: SELECT c.oid,
  n.nspname,
  c.relname
FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relname OPERATOR(pg_catalog.~) '^(dw_fct_xxx)$' COLLATE pg_catalog.default
  AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 2, 3;

Expected behavior I should get description of the table

Version: 0.35.7

maver1ck avatar Apr 14 '24 19:04 maver1ck

Still reproduces on v0.36.4, query pushdown on.

igorlukanin avatar Sep 30 '24 11:09 igorlukanin

Still reproduces on v1.1.15

fabricebaranski avatar Jan 21 '25 10:01 fabricebaranski