Troels Arvin <troels@xxxxxxxx> 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
