Troels Arvin <troels(at)arvin(dot)dk> writes:
> In a Postgres installation, I have databases where the locale is
> slightly different. Which one is correct? Excerpt from "psql --list":
> test1 | loc_test | UTF8 | libc | en_US.UTF-8 |
> en_US.UTF-8
> test3 | troels | UTF8 | libc | en_US.utf8 |
> en_US.utf8
On most if not all platforms, both those spellings of the locale names
will be taken as valid. You might try running "locale -a" to get an
idea of which one is preferred according to your current libc
installation ... but TBH, I doubt it's worth worrying about.
regards, tom lane