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 1sP5f5-002q2b-Gn for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 19:29:03 +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 1sP5f3-00BcbH-DB for pgsql-general@arkaria.postgresql.org; Wed, 03 Jul 2024 19:29:02 +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 ) id 1sP5f3-00BcZn-1L for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 19:29:01 +0000 Received: from mail-qt1-x833.google.com ([2607:f8b0:4864:20::833]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sP5f1-000Gcq-NG for pgsql-general@lists.postgresql.org; Wed, 03 Jul 2024 19:29:01 +0000 Received: by mail-qt1-x833.google.com with SMTP id d75a77b69052e-444fa159caeso45817651cf.0 for ; Wed, 03 Jul 2024 12:28:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720034938; x=1720639738; darn=lists.postgresql.org; h=subject:from:to:content-language:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=H8QxdZS0+o1FtIEdtJJHxSHh3RYirJNdef+WpUhW+nU=; b=ia2VXuLhv5sPimOPuU8z8zOpqZl8wSg0A1AgRwc4skP67gk+c6qNneEDUwPAHXULGA ZFja+c+muaI3ab8YHT2lezleHLGNI9ccE0vgMWdr1IF44qiCnSstniwB75/b665zair6 lHq2GuoawGXoiy1xRFVuzsbi0x5f6X3CYzNpKyK/MGb6+MHVg5ocyTnAJ9thXodWmjfg dTvgax41W1R+B+kjH4wDr4bOUluSItTF1Q8JHoSGBMB/SjR6DSWPYp/tHN5JFHP+NcwH 8PZb9L5co9dNpuS8l/v6B40QnYWL5QzCuScmL5NQn+U09g5C21ctYztGPU7RwUmLe0Cg cQdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720034938; x=1720639738; h=subject:from:to:content-language:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=H8QxdZS0+o1FtIEdtJJHxSHh3RYirJNdef+WpUhW+nU=; b=ZIbvAZJtWGl0XSKmo5Y29ntYtZ5R/EG9CAtWNE0PCRPHtfKi2Tos/bMjRTtS3mobPk Ei+H7XGzXVcOnsTTZzzJVwSd9z0ugga1oi1ir/Ye5FeXJsK2w9D+yl75WdBY8hkl2VtU nX0VKsl1KdsHZbC/lIv3tsItIcRkVY7XO4elBDS9H2d3x+PGWKFbEKYhiuZSasy0s1qo ln0KIndrjgOVkkWLQD04tdy/PhVaX03f4pDXcz8DFTLnifnP6HTLu3O/EWe61tJgERo7 P9kKwxqLaBDQeJ0Tv6czCC2EUzqufIb1dHox+l8P3lDtuumSh5g24Lr03uDb9ohshE7U GXzg== X-Gm-Message-State: AOJu0YwpVNYeHpXNu4RhGRJbJ06MDYLquZYvPpVqKpV8kse9XQiTD0tR w7PzMSmpChjXWEIuh/h8v7dCGR43YCMV2TM6eMafi0q/eApK5ws3nYvZrQ== X-Google-Smtp-Source: AGHT+IEuiU4UbTM0twOeO4XmuJpg4He9bvg38ie5bF3vdwkZHyPwW5j9wRRK6auCCzylIqqMnQmHVA== X-Received: by 2002:a05:6214:19ce:b0:6b0:4201:3840 with SMTP id 6a1803df08f44-6b5b7148e19mr173336846d6.40.1720034937564; Wed, 03 Jul 2024 12:28:57 -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 6a1803df08f44-6b59e60bc49sm55685246d6.104.2024.07.03.12.28.57 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 03 Jul 2024 12:28:57 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------Jz6RY1VfHl1Q0HIXdr8uMRdt" Message-ID: <341b85fb-0085-95ea-1177-fc96944295e2@gmail.com> Date: Wed, 3 Jul 2024 15:28:56 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Content-Language: en-US To: pgsql-general@lists.postgresql.org From: Kent Dorfman Subject: Description field for tables and views 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. --------------Jz6RY1VfHl1Q0HIXdr8uMRdt Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SSB0aGluayBJIGFscmVhZHkga25vdyB0aGUgYW5zd2VyIGJ1dCBhc2tpbmcgaGVyZSBpcyBw cm9iYWJseSBxdWlja2VyIA0KdHVybmFyb3VuZCB0aGFuIHJlc2VhcmNoaW5nIGl0Lg0KDQpJ J3ZlIGdvdHRlbiBpbnRvIGEgInZpZXcgYmxvYXQiIHNjZW5hcmlvIHdpdGggbWFueSBtYW55 IGN1c3RvbSB2aWV3cyANCnRoYXQgSSBjYW5ub3QgcmVtZW1iZXIgd2hhdCB0aGV5IGFjdHVh bGx5IGRvLsKgIElzIHRoZXJlIGFueSBwc3FsIA0KZnVuY3Rpb24vY29tbWFuZCB0byBhZGQg YSBkZXNjcmlwdGlvbiBmaWVsZCB0byBhIHRhYmxlIG9yIHZpZXcgDQpkZWZpbml0aW9uIGlu IHRoZSBzeXN0ZW0/wqAgV291bGQgYmUgbmljZSB0byBoYXZlIGEgb25lIGxpbmUgZ2VuZXJh bCB0ZXh0IA0Kbm90ZSBjYXBhYmlsaXR5IHRvIHF1aWNrbHkgc2VlIHdoYXQgYSBjb21wbGlj YXRlZCB2aWV3IGRvZXMgd2hlbiBsb29raW5nIA0KYXQgdGhlIGRlZmludGlvbiB2aWENCiMg XGR2Kw0KDQpMb29rcyBsaWtlIHRoZSBjb21tYW5kIGhhcyB0aGUgZmllbGQgcHJlc2VudCwg YnV0IG5vdCBzdXJlIGhvdyB0byANCnBvcHVsYXRlIGl0Lg0KDQphbSB1c2luZyBQb3N0Z3Jl U1FMIDEzLnh4IGluIERlYmlhbi4NCg0KDQo= --------------Jz6RY1VfHl1Q0HIXdr8uMRdt Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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.=C2=A0 Is there any psql= function/command to add a description field to a table or view definition in the system?=C2=A0 Would be nice to have a one line gene= ral 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.


--------------Jz6RY1VfHl1Q0HIXdr8uMRdt--