> On Jul 3, 2024, at 13:24, Kent Dorfman 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.
On 7/3/24 15:30, Christophe Pettus wrote:
On Jul 3, 2024, at 12:28, Kent Dorfman 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/
Στις 3/7/24 22:28, ο/η Kent Dorfman έγραψε:
I think I already know the answer but asking here is probably quicker
turnaround than researching it.
I've gotten into a "view bloat" scenario with many many custom views
that I cannot remember what they actually do. Is there any psql
function/comm
Comment is probably what you’re looking for.
If you don’t want to use that: it’s a database. Make a table. Put whatever
information in there that you need.
Either look up by view name, or schema + view name, or oid:
https://www.postgresql.org/docs/current/datatype-oid.html
> On Jul 3, 2024, at
> On Jul 3, 2024, at 12:28, Kent Dorfman 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
