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)
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)