Re: Description field for tables and views

From: Kent Dorfman <kent(dot)dorfman766(at)gmail(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Description field for tables and views
Date: 2024-07-03 20:24:12
Message-ID: 8c98234b-0e33-37b4-e18d-433e10775154@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/3/24 15:30, Christophe Pettus wrote:
>
>> On Jul 3, 2024, at 12:28, Kent Dorfman<kent(dot)dorfman766(at)gmail(dot)com> wrote:
>>
>> Is there any psql function/command to add a description field to a table or view definition in the system?
> Allow me to introduce you to my good friend "COMMENT":
>
> https://www.postgresql.org/docs/current/sql-comment.html
Thanks for the hint!

It's the simplest and most direct solution.  Been typing SQL for 40
years and haven't had occasion to use COMMENT.  Is it SQL standard or
postgres specific?  Am not a DBA by trade but an embedded systems guy.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2024-07-03 20:25:55 Re: Description field for tables and views
Previous Message Achilleas Mantzios 2024-07-03 19:56:33 Re: Description field for tables and views