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