On 20.02.2026 18:48, Álvaro Herrera wrote:
> So if you want details but
> no comments, you use "\d+", and if you want comments but no details you
> use "\d*", and if you want everything, then you use \d+* or \d*+?
We need to keep in mind two more modifiers: S for system objects and x
for eXtended mode.
So it may be looks like slightly awkward: \dSx+*
Another option is to use psql variable (for example ECHO_COMMENTS
on/off) to force comments in \d* commands.
I'm not sure what option is better. But I like the idea of printing
comments.
--
Pavel Luzanov
Postgres Professional: https://postgrespro.com