From: Tom Lane <tgl@sss.pgh.pa.us>
To: marcelo mendoza <jmarcelo.mendoza@gmail.com>
cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-novice@postgresql.org
Subject: Re: Change collate postgresql
In-reply-to: 
 <CAPSkOeUX2+f+FvjRMBD6dHet0u5=992oOqA5cE2sE_p31x5nWQ@mail.gmail.com>
References: 
 <CAPSkOeW8RNpaZfqVpwZz35dpL+8_gbc8dzmfV+AZOy9+wXEZfA@mail.gmail.com>
 <196166551a133215f5f3f7510f1403c82c774bff.camel@cybertec.at>
 <CAPSkOeUX2+f+FvjRMBD6dHet0u5=992oOqA5cE2sE_p31x5nWQ@mail.gmail.com>
Comments: In-reply-to marcelo mendoza <jmarcelo.mendoza@gmail.com>
	message dated "Wed, 19 Aug 2020 09:06:52 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1401862.1597845366.1@sss.pgh.pa.us>
Date: Wed, 19 Aug 2020 09:56:06 -0400
Message-ID: <1401863.1597845366@sss.pgh.pa.us>
Precedence: bulk

marcelo mendoza <jmarcelo.mendoza@gmail.com> writes:
> 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?

I'm guessing that you specified LC_COLLATE that way when you created
the database.  Postgres won't complain if setlocale() doesn't, which
it very possibly wouldn't.

I don't believe we offer any DDL command to change that, so a direct
UPDATE on pg_database is the only way.  Should be pretty harmless
as long as you don't try to change the setting to a functionally
different value.

			regards, tom lane