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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi Laurenz, this is the space en_US.UTF- 8 (the space is before the 8)

Collate           | en_US.UTF-

                  | 8


The database was created in this way, without error, how can I fix this? 

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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Change collate postgresql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Change collate postgresql