Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Description field for tables and views
From: Guyren Howe <guyren@gmail.com>
In-Reply-To: <341b85fb-0085-95ea-1177-fc96944295e2@gmail.com>
Date: Wed, 3 Jul 2024 12:45:07 -0700
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <5F815B1A-3FD8-41A7-8BE7-0559066F8B96@gmail.com>
References: <341b85fb-0085-95ea-1177-fc96944295e2@gmail.com>
To: Kent Dorfman <kent.dorfman766@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/5F815B1A-3FD8-41A7-8BE7-0559066F8B96%40gmail.com>
Precedence: bulk

Comment is probably what you=E2=80=99re looking for.

If you don=E2=80=99t want to use that: it=E2=80=99s 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 <kent.dorfman766@gmail.com> =
wrote:
>=20
> I think I already know the answer but asking here is probably quicker =
turnaround than researching it.
>=20
> 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=20
> # \dv+
>=20
> Looks like the command has the field present, but not sure how to =
populate it.
>=20
> am using PostgreSQL 13.xx in Debian.
>=20
>=20