Re: Per-column collation

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2010-11-16T20:56:04Z
Lists: pgsql-hackers
On tis, 2010-11-16 at 21:40 +0100, Pavel Stehule wrote:
> ok, then we should to define this alias manually
> 
> some like - CREATE COLLATE "czech" FOR LOCALE "cs_CZ.UTF8"
> 
> or some similar. Without this, the application or stored procedures
> can be non portable between UNIX and WIN.

Yes, such a command will be provided.  You can already do it manually.

> Peter, now initdb check relation between encoding and locale - and
> this check is portable. Can we use this code?

Hmm, not really, but something similar, I suppose.  Only that the
mapping list would be much longer and more volatile.