Re: Setting "ucs_basic" as the default database collation

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Sun, Oct 27, 2024 at 5:32 AM Christophe Pettus <xof@xxxxxxxxxxxx> wrote:

Is there a way to specify "ucs_basic" (or the other "standard collations" [1]) collation as the default database collation at database creation time, rather than on a per-column or per-operation basis?

[1] https://www.postgresql.org/docs/current/collation.html#COLLATION-MANAGING-STANDARD

https://www.postgresql.org/docs/16/sql-createdatabase.html

 

The CREATE DATABASE statement has an ENCODING option.  Does that work with 'ucs_basic'?

--

Death to <Redacted>, and butter sauce.

Don't boil me, I'm still alive.

<Redacted> crustacean!