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