public inbox for [email protected]  

help / color / mirror / Atom feed

From: Guyren Howe <[email protected]>
To: Kent Dorfman <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Description field for tables and views
Date: Wed, 3 Jul 2024 12:45:07 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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 12:28, Kent Dorfman <[email protected]> wrote:
> 
> 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/command to add a description field to a table or view definition in the system?  Would be nice to have a one line general text note capability to quickly see what a complicated view does when looking at the defintion via 
> # \dv+
> 
> Looks like the command has the field present, but not sure how to populate it.
> 
> am using PostgreSQL 13.xx in Debian.
> 
> 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Description field for tables and views
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox