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.