Re: Dumping/Restoring with constraints? - Mailing list pgsql-general

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?