The \d [ PATTERN ] Meta-Commands
This section describes the various \d meta-commands.
All \d
meta-commands take an optional pattern (asterisk [ *
] or question mark [ ?
]) and return only the records that match that pattern.
The ?
argument is useful if you can't remember if a table name uses an underscore or a dash:
=> \dn v?internal
List of schemas
Name | Owner
------------+---------
v_internal | dbadmin
(1 row)
The output from the \d
metacommands places double quotes around non-alphanumeric table names and table names that are keywords, such as in the following example.
=> CREATE TABLE my_keywords.precision(x numeric (4,2));
CREATE TABLE
=> \d
List of tables
Schema | Name | Kind | Owner
--------------+-----------------------+-------+---------
my_keywords | "precision" | table | dbadmin
Double quotes are optional when you use a \d
command with pattern matching.