Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sP5h3-002qGj-Fp
	for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 19:31:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sP5h1-00Bfl4-G4
	for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 19:31:04 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1sP5h1-00Bfkw-5O
	for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 19:31:03 +0000
Received: from smtp87.ord1d.emailsrvr.com ([184.106.54.87])
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1sP5gz-000GeK-7O
	for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 19:31:03 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp11.relay.ord1d.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id BAB6860265;
	Wed,  3 Jul 2024 15:30:58 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Description field for tables and views
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <341b85fb-0085-95ea-1177-fc96944295e2@gmail.com>
Date: Wed, 3 Jul 2024 12:30:28 -0700
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <F6D1BC76-2E01-4CE6-80F8-FE6B234808B1@thebuild.com>
References: <341b85fb-0085-95ea-1177-fc96944295e2@gmail.com>
To: Kent Dorfman <kent.dorfman766@gmail.com>
X-Mailer: Apple Mail (2.3774.600.62)
X-Classification-ID: 85aedd8c-22c5-4ba3-82f0-de6b4caaeb7b-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/F6D1BC76-2E01-4CE6-80F8-FE6B234808B1%40thebuild.com>
Precedence: bulk



> On Jul 3, 2024, at 12:28, Kent Dorfman <kent.dorfman766@gmail.com> =
wrote:
>=20
> 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=