Re: COLLATE

On Thu, 14 Aug 2003, Juan Francisco Diaz wrote:

> hi, I am migratin a database from Ms Sql Server 2000 to PostgreSQL 7.3.
> So long i've been unable to find an equivalent to the COLLATE clause in
> the create table statement available in sql server. How can I define
> the character set to be used in a postgres db, table or column?

You can currently only specify the collation at initdb time and for the
entire cluster which you can do by setting the appropriate environment
variables for the initdb (I usually use something like
LANG="" initdb ... )

You might be interested in recent discussions on pgsql-general that relate
to this subject.