Subject: Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands

From: Jim Jones <[email-masked]>
Date: Thu, 26 Feb 2026 11:23:40 +0100

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