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
>
>
>
>
>

Reply via email to