pgcli icon indicating copy to clipboard operation
pgcli copied to clipboard

\dS command not recognized in pgcli (works in psql)

Open ganeshbabugb opened this issue 3 months ago • 0 comments

In PostgreSQL’s native psql client, the \dS command is used to list all relations, including system objects (from the pg_catalog and information_schema schemas).

However, in pgcli, running \dS results in an error. It appears that pgcli currently does not support the S suffix variants (e.g., \dtS, \dvS, \dS) that toggle visibility of system objects.

Suggested Improvement

Add support for the S suffix in \d meta-commands, similar to psql. That is, allow commands such as:

\dtS — list all tables (including system tables) \dvS — list all views (including system views) \dS — list all relations (including system relations)

ganeshbabugb avatar Oct 29 '25 16:10 ganeshbabugb