public inbox for [email protected]
help / color / mirror / Atom feedRe: Description field for tables and views
2+ messages / 2 participants
[nested] [flat]
* Re: Description field for tables and views
@ 2024-07-03 20:24 Kent Dorfman <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Kent Dorfman @ 2024-07-03 20:24 UTC (permalink / raw)
To: Christophe Pettus <[email protected]>; +Cc: [email protected]
On 7/3/24 15:30, Christophe Pettus wrote:
>
>> On Jul 3, 2024, at 12:28, Kent Dorfman<[email protected]> 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Description field for tables and views
@ 2024-07-03 20:25 Christophe Pettus <[email protected]>
parent: Kent Dorfman <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Christophe Pettus @ 2024-07-03 20:25 UTC (permalink / raw)
To: Kent Dorfman <[email protected]>; +Cc: [email protected]
> On Jul 3, 2024, at 13:24, Kent Dorfman <[email protected]> wrote:
> Is it SQL standard or postgres specific?
It's not in the SQL standard (at the bottom of each page for each SQL command is a note regarding its relationship with the SQL standard). Other DBMS implement something similar, however.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-07-03 20:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-07-03 20:24 Re: Description field for tables and views Kent Dorfman <[email protected]>
2024-07-03 20:25 ` Christophe Pettus <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox