Re: How to find correct locale name for CREATE DATABASE

On 1 Dec 2010, at 21:46, Andrus wrote:

> Alban,
>
>> Seriously though, functionality like that has no place in a database server. That's the responsibility of the OS, or if it lacks in that respect, for third-party tools.
>
> Thank you.
> So only portable way is to probe Postgres 9 locales using CREATE DATABASE command with expected locale names hoping that some call suceeds?

Well... if you really have to insist on using Postgres to determine system locales, I suppose you could do that - just like you can use a crane to park your car. It's not a very sensible thing to attempt before looking at alternative solutions though.

I imagine there must be tools for that purpose, or otherwise some programming language will probably have functions for this that you can use. Using the database server for this would be the last thing I'd try.
I can't say I'm too well-versed in locale usage though, I usually just stick with English.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.

!DSPAM:737,4cf6cd4e802658319426940!