Thanks - I don't show any locale: rbt_development=> \l List of databases Name | Owner | Encoding ----------------------------+---------------------+---------- rbt_development | rbt | UTF8 ...
On Wed, Jul 22, 2009 at 6:45 PM, Andreas Wenk < a.w...@netzmeister-st-pauli.de> wrote: > Robert James wrote: > >> Thank you, Tom. I guess I'm a bit confused about things here. How can I >> find the locale of my database? (I wasn't able to find this in the docs). >> If I do have the locale set to 'C', do I loose anything by using utf8 for >> all text fields? >> > > use psql: > > postgres=# \l+ > List of databases > Name | Owner | Encoding | Collation | Ctype | > ----------------+-----------+----------+-------------+-------------+ > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | > > output shortend ;-) > > Cheers > > Andy > > > > >