Using postgres table description

Question

In postgres while listing the relation with \dt+ new columns 'size' and 'Description' column are added. As the name suggests Description can we use to store the description of the table, if yes how?

# \dt
        List of relations
 Schema |  Name   | Type  | Owner 
--------+---------+-------+-------
 drs    | Records | table | rho
 drs    | Reports | table | rho
(2 rows)

# \dt+
                      List of relations
 Schema |  Name   | Type  | Owner |    Size    | Description 
--------+---------+-------+-------+------------+-------------
 drs    | Records | table | rho   | 8192 bytes | 
 drs    | Reports | table | rho   | 0 bytes    | 
(2 rows)

user330315 · Accepted Answer · 2019-08-16 06:18:07Z

2

This can be defined using the comment statement:

comment on table drs."Reports" is 'This table stores reports';

answered Aug 16, 2019 at 6:18

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using postgres table description

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related