On Sun, 26 Apr 2015 10:31:37 +0200 "Gunnar \"Nick\" Bluth" <gunnar.bluth@xxxxxxxxxxx> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen: > > My databases looks like this...: > > > > > > List of databases Name | Owner | Encoding | Collate > > | Ctype | Access privileges > > --------------+--------------+----------+-------------+-------------+- > - ---------------------- > > > > > dbname | owner | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > > ....... > > > > > > And my problem is that I am using Norwegian in some tables and when > > using order by the sort order is not correct for the Norwegian > > letters.. So my guestion is if it is possible to get the correct > > sort order without recreating all my databases or initialize > > PGSQL? > > > Sure (i.e., if you're on a half recent version): > > ALTER TABLE <yourtable> ALTER COLUMN <yourcolumn> COLLATE <collation> > > > http://www.postgresql.org/docs/9.4/static/sql-altertable.html > Yes, I am using 9.4.x so I will check this out... Thx... :) BTJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
