Skip to content

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

Closed
dbcli/pgspecial
#162

Description

@ganeshbabugb

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)

Activity

  1. ganeshbabugb commented on Jul 24, 2026

    @ganeshbabugb
    Author

    Thanks everyone for your support!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions