Message-ID: <45be5f61-6153-4f32-a3f9-4392d3e14d48@uni-muenster.de>
Date: Thu, 26 Feb 2026 11:23:40 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands
To: Fujii Masao <masao.fujii@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: <CAHGQGwGL4JqiKA26fnGx-cTM=VzoTs_uzqejvj4Fawyr4uLUUw@mail.gmail.com>
 <82b25785-0dc1-46d6-93ac-ce385a3a0bfc@uni-muenster.de>
 <CAHGQGwFJKg-aT5vajSU1v_B4K129u_SjZ3EGGHFSBhW967gcMA@mail.gmail.com>
Content-Language: de-DE, en-GB
From: Jim Jones <jim.jones@uni-muenster.de>
In-Reply-To: <CAHGQGwFJKg-aT5vajSU1v_B4K129u_SjZ3EGGHFSBhW967gcMA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/45be5f61-6153-4f32-a3f9-4392d3e14d48%40uni-muenster.de>
Precedence: bulk


On 26/02/2026 04:32, Fujii Masao wrote:
> I'm not sure why this behavior isn't documented, but it seems worth
> addressing in a separate documentation patch.

Yeah, it also surprised me a bit. Having a NULL instead of '' in \d* is
IMO not that dramatic, but things get different when accessing the
catalog directly, e.g.

postgres=# \pset null '(null)'
postgres=# CREATE TABLE t (id int);
CREATE TABLE
postgres=# COMMENT ON TABLE t IS '';
COMMENT
postgres=# SELECT obj_description('t'::regclass, 'pg_class');
 obj_description
-----------------
 (null)
(1 row)

Best, Jim