Date: Tue, 6 Sep 2022 14:25:26 +0200
From: Christoph Berg <myon@debian.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
	pgsql-hackers@lists.postgresql.org
Subject: psql -l and locales (Re: pgsql: Add option to use ICU as global
 locale provider)
Message-ID: <Yxc8NoC0chLC7bfX@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	Tom Lane <tgl@sss.pgh.pa.us>,
	Peter Eisentraut <peter.eisentraut@enterprisedb.com>,
	pgsql-hackers@lists.postgresql.org
References: <E1nUnH5-0006aR-MX@gemulon.postgresql.org>
 <YjYYmsLr9mzqI4Jq@msg.df7cb.de>
 <2298daf1-c9c7-be30-7319-519a768b9405@enterprisedb.com>
 <YjivDPvI9TMa5ppu@msg.df7cb.de>
 <2158266.1647887832@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <2158266.1647887832@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/Yxc8NoC0chLC7bfX%40msg.df7cb.de>
Precedence: bulk

Re: Tom Lane
> Christoph Berg <myon@debian.org> writes:
> > A possible solution might be to rip out all the locale columns except
> > "Encoding" from \l, and leave them in place for \l+.
> 
> I'd rather see a single column summarizing the locale situation.
> Perhaps it could be COALESCE(daticulocale, datcollate), or
> something using a CASE on datlocprovider?
> Then \l+ could replace that with all the underlying columns.

Fwiw I still think the default psql -l output should be more concise.
Any chance to have that happen for PG15?

I can try creating a patch if it has chances of getting through.

Christoph