Skip site navigation (1) Skip section navigation (2)


From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Juan Francisco Diaz <jfd(at)007mundo(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: COLLATE
Date: 2003-08-15 04:45:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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="<whatever>" initdb ... )

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

In response to

  • COLLATE at 2003-08-14 15:42:08 from Juan Francisco Diaz

pgsql-novice by date

Next:From: cristiDate: 2003-08-15 09:22:50
Subject: currval/sequence
Previous:From: Cath LawrenceDate: 2003-08-15 01:46:07
Subject: Re: Large object - what's happening?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group