-----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
- --
Gunnar "Nick" Bluth
RHCE/SCLA
Mobil +49 172 8853339
Email: gunnar.bluth@pro-open.de
_____________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX.
Ten years later they are choosing Windows over UNIX.
What part of that message aren't you getting? - Tom Payne
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (MingW32)
iQEcBAEBAgAGBQJVPKJoAAoJEBAQrmsyiTOMhRsH/3RENBEhVBHCKpAURq9EdPdj
gEB8vD9PY2U/m5L3vG/RrqNhtPbIhVsfLn0CUSqhTTh4VEmoiGIbRS8MTDxH79Nl
Ic/ovsjioPy7feIPBKRKALTY4R+8KG/XAIuY2WEWUcy3NTr5NX3id+BcHnOc5nXU
PB7QB3VD5a3YykWVE6/6OxskeoSiEN97ey4vbdav9qNNSQ60zt0gJa9SR7nGHsaV
M8yF9fG57TeUFrTaEkZNkmZwC4Ui4w+eKFZk0m9L13JXaoZ4xIqLvH1nufKIO0uB
SHBUl22MGKZoksg1KaAEvq6lYLGfdOvH53tsulw4nDR0w+VYztY4eIR0j1xm17c=
=Sh2G
-----END PGP SIGNATURE-----
