On 8/30/08, Adrian Klaver <aklaver@comcast.net> wrote:
>
> Might also be useful to do SHOW ALL from within the database cluster you have
> on your restore machine. Will show what choices initdb made.
>
> test=# SHOW all;
> <Snip>
> lc_collate | en_US.UTF-8
> lc_ctype | en_US.UTF-8
> lc_messages | en_US.UTF-8
> lc_monetary | en_US.UTF-8
> lc_numeric | en_US.UTF-8
> lc_time | en_US.UTF-8
> <Snip>
Thanks. I did this and LC_COLLATE etc have the values "C". How can I
change this to UTF8?