Add a Comment in Postgres
Today I learned about a neat Postgres feature, commenting. Here is a query adding a comment to a table:
> comment on table developers is 'these are the authors'; COMMENT
Let's check see our comment
> \dt+ developers; List of relations -[ RECORD 1 ]---------------------- Schema | public Name | developers Type | table Owner | jwworth Size | 16 kB Description | these are the authors
You can comment on many things. Use this wherever you feel a comment is necessary or appropriate.
h/t Chris Erin and Jack ChristensenTweet