Re: Change collate postgresql
| От | marcelo mendoza |
|---|---|
| Тема | Re: Change collate postgresql |
| Дата | |
| Msg-id | CAPSkOeUX2+f+FvjRMBD6dHet0u5=992oOqA5cE2sE_p31x5nWQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Change collate postgresql (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: Change collate postgresql
|
| Список | pgsql-novice |
Hi Laurenz, this is the space en_US.UTF- 8 (the space is before the 8)
Collate | en_US.UTF-
| 8
Regards
--
El mié., 19 ago. 2020 a las 1:59, Laurenz Albe (<laurenz.albe@cybertec.at>) escribió:
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
Marcelo Mendoza
(0983) 383-752
В списке pgsql-novice по дате отправления: