Dennis Gearon <gearond(at)fireserve(dot)net> writes:
> I didn't see anything that said what the LC_COLLATE and LC_TYPE settings were when initdb was done.
> How can I find that out?
In 7.4 you can just SHOW 'em, but before that you have to use
pg_controldata to find it out.
> in postgresql.conf
> ------------------
> LC_MESSAGES = 'C'
> LC_MONETARY = 'C'
> LC_NUMERIC = 'C'
> LC_TIME = 'C'
Given that I'd bet you have collate/ctype as C too, but it's not
certain.
regards, tom lane