Re: PSQL schema "describe" \dn is not escaping quotes

From: JiaoShuntian <jiaoshuntian(at)gmail(dot)com>
To: Peter Smith <smithpb2250(at)gmail(dot)com>
Cc: Nishant Sharma <nishant(dot)sharma(at)enterprisedb(dot)com>, Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>, Steven Niu <niushiji(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PSQL schema "describe" \dn is not escaping quotes
Date: 2026-08-14 07:19:54
Message-ID: 57f22280-4df0-4e52-93b3-af2e95bc8c36@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Peter,

I applied v3 and gave it a test today. Some notes:

1) v3-0001-Fix-escapes-for-psql-describe-schema-patterns.patch applies
cleanly with `git am` on top of current master (tip 1f97b252dfe).

2) publication regression test passes cleanly, including the new
embedded-quote cases you added. No diffs.

3) I also performed a manual test on an instance:

CREATE SCHEMA "it's a bug";
\dn "it's a bug"
With v3 applied it now correctly returns:

List of schemas
Name | Owner
------------+--------------
it's a bug | jiaoshuntian
(1 row)

So the fix behaves as described and the test coverage looks adequate
to me.

Regards,
Shuntian Jiao

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-08-14 09:18:29 RE: Per-table resync for logical replication subscriptions
Previous Message Peter Smith 2026-08-14 06:55:18 Re: Support EXCEPT for TABLES IN SCHEMA publications