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 ) id 1sP6Wa-002tJs-An for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 20:24:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sP6WX-00Bxl0-Cq for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 20:24:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sP6WW-00Bxkr-SQ for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 20:24:17 +0000 Received: from mail-qk1-x730.google.com ([2607:f8b0:4864:20::730]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sP6WU-000Fmh-SG for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 20:24:16 +0000 Received: by mail-qk1-x730.google.com with SMTP id af79cd13be357-79c0abd3eaaso432458185a.2 for ; Wed, 03 Jul 2024 13:24:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720038253; x=1720643053; darn=lists.postgresql.org; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=91CxIGXU+8cA1RsdDaCiAPJZLMSpIzipsD0j2eJIE5Q=; b=eOcdGaEXEw0g7iY1DHvWlT/qj8dUNnlAW7EBY+C61Nxf5xqO/7OK4eQjD5dkOC+PIf E4ZpmgpkPL9E5gRML16zkmpZ/uFELU9dJN0cbpCnxTCpjvoMskCZaHCpY15WQKNlVFO6 vgXXHM9pxARgrcy+yl5fqZ+QJc9GkJYy0MpsTjI+1kQw6QwL3utMny7i47XNMqI+FExi pTFFTJbh0mkFzj7Plt7B61O8ZzhTAhna0bnazrCqPjf/sG9K1sCRKZbLFhHnHMkfTujk rcy7+p1lhCkqqygPiCMe2pSFuvUKlTLIRMDZl+2M8X2azrn7a0yK9VxvlU2wS9VPbYvd nwpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720038253; x=1720643053; h=in-reply-to:from:references:cc:to:content-language:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=91CxIGXU+8cA1RsdDaCiAPJZLMSpIzipsD0j2eJIE5Q=; b=RgNEdssy8f23RIYhHo38mEVm77SOqMhWHxKOCnzgnXHgiSm37wJhgX9TbudFrj8l6c qDuOMAkw+FOyQSyiY4dg5qFJuIijrAYPB6UtQLruJ4tmn1ddqV3pK1887bnO2rF/I0ns jc8uBNGQ0WdZleRZqsPuGE6ui9LQkEG4VoPcnXAIiECEA7zNx05hX4edT6dGhl3LkhBI oF1QOFEa/b3LYnVEqepPeH3vfvHvH6xwV2Vfaf2MMfIWP2TQU9xO8kT1083RiYb7X2cU 5LQPL9yECvpdfZQPZ3NDkJogMGIgco/xudHBEVCZkyof3psppZM77wU+gTlSwsEE3Mb8 9aXA== X-Gm-Message-State: AOJu0YwuBBm7uCwAju3lhKdKPBD1Gw11GiNDTzm63aAjQGqc1Xa5WqPO YhXteyiZL8P9p4khVzi/BQ5OArbpcTwTJuADAvlAr9f/vBXy8Edf X-Google-Smtp-Source: AGHT+IGO9EyOx399jq0cV1jRg/+KJrv3sM5um6sNWiDBHqX+R3ZGvVzatkCb7k2xsuEE/yiwBBk74w== X-Received: by 2002:a05:620a:2154:b0:79d:6bba:4a66 with SMTP id af79cd13be357-79d7babe6d5mr1395146785a.66.1720038253265; Wed, 03 Jul 2024 13:24:13 -0700 (PDT) Received: from [10.1.11.102] (c-73-214-125-50.hsd1.pa.comcast.net. [73.214.125.50]) by smtp.gmail.com with ESMTPSA id af79cd13be357-79d6932c8e5sm593353285a.131.2024.07.03.13.24.12 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 03 Jul 2024 13:24:12 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------Mmbp0Wyt9P313uSd0mZ03S0f" Message-ID: <8c98234b-0e33-37b4-e18d-433e10775154@gmail.com> Date: Wed, 3 Jul 2024 16:24:12 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Description field for tables and views Content-Language: en-US To: Christophe Pettus Cc: pgsql-general@lists.postgresql.org References: <341b85fb-0085-95ea-1177-fc96944295e2@gmail.com> From: Kent Dorfman In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Mmbp0Wyt9P313uSd0mZ03S0f Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gNy8zLzI0IDE1OjMwLCBDaHJpc3RvcGhlIFBldHR1cyB3cm90ZToNCj4NCj4+IE9uIEp1 bCAzLCAyMDI0LCBhdCAxMjoyOCwgS2VudCBEb3JmbWFuPGtlbnQuZG9yZm1hbjc2NkBnbWFp bC5jb20+ICB3cm90ZToNCj4+DQo+PiBJcyB0aGVyZSBhbnkgcHNxbCBmdW5jdGlvbi9jb21t YW5kIHRvIGFkZCBhIGRlc2NyaXB0aW9uIGZpZWxkIHRvIGEgdGFibGUgb3IgdmlldyBkZWZp bml0aW9uIGluIHRoZSBzeXN0ZW0/DQo+IEFsbG93IG1lIHRvIGludHJvZHVjZSB5b3UgdG8g bXkgZ29vZCBmcmllbmQgIkNPTU1FTlQiOg0KPg0KPiAJaHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvZG9jcy9jdXJyZW50L3NxbC1jb21tZW50Lmh0bWwNClRoYW5rcyBmb3IgdGhlIGhp bnQhDQoNCkl0J3MgdGhlIHNpbXBsZXN0IGFuZCBtb3N0IGRpcmVjdCBzb2x1dGlvbi7CoCBC ZWVuIHR5cGluZyBTUUwgZm9yIDQwIA0KeWVhcnMgYW5kIGhhdmVuJ3QgaGFkIG9jY2FzaW9u IHRvIHVzZSBDT01NRU5ULsKgIElzIGl0IFNRTCBzdGFuZGFyZCBvciANCnBvc3RncmVzIHNw ZWNpZmljP8KgIEFtIG5vdCBhIERCQSBieSB0cmFkZSBidXQgYW4gZW1iZWRkZWQgc3lzdGVt cyBndXkuDQo= --------------Mmbp0Wyt9P313uSd0mZ03S0f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
On 7/3/24 15:30, Christophe Pettus wrote:


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

It's the simplest and most direct solution.=C2=A0 Been typing SQL for= 40 years and haven't had occasion to use COMMENT.=C2=A0 Is it SQL standa= rd or postgres specific?=C2=A0 Am not a DBA by trade but an embedded sys= tems guy.
--------------Mmbp0Wyt9P313uSd0mZ03S0f--