psql table description
That shows comments that you define using the command comment on:

The following table definition:

create table foo
(
  id integer primary key, 
  name text not null
);

comment on table foo is 'This is the famous foo table';
comment on column foo.id is 'This is the primary key';
comment on column foo.name is 'This is the name of the thing';


Will then show up like this:

postgres&gt; \d+
                                List of relations
 Schema |   Name    | Type  | Owner  |    Size    |         Description
--------+-----------+-------+--------+------------+------------------------------
 public | foo       | table | thomas | 8192 bytes | This is the famous foo table
(1 row)

postgres&gt; \d+ foo
                                             Table "public.foo"
 Column |  Type   | Collation | Nullable | Default | Storage  | Stats target |          Description
--------+---------+-----------+----------+---------+----------+--------------+-------------------------------
 id     | integer |           | not null |         | plain    |              | This is the primary key
 name   | text    |           | not null |         | extended |              | This is the name of the thing
Indexes:
    "foo_pkey" PRIMARY KEY, btree (id)


postgres&gt;