Barry Lind <barry(at)xythos(dot)com> writes:
> I meant to ask this the last time this came up on the list, but now is a
> good time. Given what Tom describes below as the behavior in 7.1
> (initdb stores the locale info), how do you determine what locale a
> database is running in in 7.1 after initdb?
Hm. There probably ought to be an inquiry function or SHOW variable
for that, but at the moment there's not. Offhand I can't think of any
direct way except to paw through the pg_control file looking for the
locale name (at least it's stored there in ASCII ;-)).
regards, tom lane