Re: Change collate postgresql
От
Laurenz Albe
Тема
Re: Change collate postgresql
Дата
Msg-id
196166551a133215f5f3f7510f1403c82c774bff.camel@cybertec.at
Ответ на
Change collate postgresql (marcelo mendoza)
Список
Дерево обсуждения
Change collate postgresql marcelo mendoza <jmarcelo.mendoza@gmail.com>
Re: Change collate postgresql Laurenz Albe <laurenz.albe@cybertec.at>
Re: Change collate postgresql marcelo mendoza <jmarcelo.mendoza@gmail.com>
Re: Change collate postgresql Tom Lane <tgl@sss.pgh.pa.us>
Re: Change collate postgresql marcelo mendoza <jmarcelo.mendoza@gmail.com>
On Tue, 2020-08-18 at 16:00 -0400, marcelo mendoza wrote:
> I have the following list of databases, but in record 3 you can see that the COLLATE has a space in the definition
I cannot see a space in the image, but it looks certainly weird.
What do you get for
SELECT d.datname,
c.collname,
c.oid AS coll_oid
FROM pg_database AS d
LEFT JOIN pg_collation AS c ON d.datcollate = c.collname;
Did you directly manipulate "pg_database" at some point?
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
В списке pgsql-novice по дате отправления
