\dS [ PATTERN ]

The \dS [ PATTERN ] meta-command (uppercase S) returns all system table (monitoring API) names from the V_CATALOG and V_MONITOR schemas.

Tip: You can get identical results running this query: SELECT * FROM system_tables;

If you specify a schema name, you can view results for tables in that schema only; however, you must use the wildcard character. For example:

=> \dS v_catalog.*

You can also run the \dS command with a table argument to return information for that table only:

vmartdb=> \dS columns
                        List of tables 
  Schema   |  Name   |  Kind  |       Description        | Comment
-----------+---------+--------+--------------------------+---------
 v_catalog | columns | system | Table column information |
(1 row)

If you provide the schema name with the table name, the output returns information about the table:

vmartdb=> \dS v_catalog.types
                        List of tables
  Schema   | Name  |  Kind  |              Description               | Comment 
-----------+-------+--------+----------------------------------------+---------
 v_catalog | types | system | Information about supported data types | 
(1 row)