From: | marcelo mendoza <jmarcelo(dot)mendoza(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Change collate postgresql |
Date: | 2020-08-19 13:06:52 |
Message-ID: | CAPSkOeUX2+f+FvjRMBD6dHet0u5=992oOqA5cE2sE_p31x5nWQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)albe(at)cybertec(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-08-19 13:56:06 | Re: Change collate postgresql |
Previous Message | Laurenz Albe | 2020-08-19 05:59:52 | Re: Change collate postgresql |