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';
COMMENTLet'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 authorsYou can comment on many things. Use this wherever you feel a comment is necessary or appropriate.
http://www.postgresql.org/docs/current/static/sql-comment.html
h/t Chris Erin and Jack Christensen
Tweet