On Sun, Oct 27, 2024 at 5:32 AM Christophe Pettus <x...@thebuild.com> 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!