CODEWITHSUNDEEP
postgresqlenums
Shane Stillwell
Shane Stillwell

Reputation: 3258

Is it possible to add a description to a user defined type?

When using the PostgreSQL cli I can run \dT and see a list of my defined ENUMs

postgres=# \dT
         List of data types    
 Schema |         Name         | Description
--------+----------------------+-------------
 public | collection_qualifier |
 public | image_class          |
 public | profile_type         |    
(3 rows)

There is a Description column, but I do not see any way to add a comment to type.

Is this possible?

Upvotes: 0

Views: 30

Answers (1)

user330315
user330315

Reputation:

Use comment on

comment on type profile_type is 'The type for profiles'

Upvotes: 1

Related Questions