Re: locale

Bruce Momjian wrote:

>Dennis Bjorklund wrote:
>  
>
>>Is anyone working to make the locale support in pg better? Running initdb
>>to set the locale is a bit heavy. It would be nice to at least be able to 
>>set it per database.
>>    
>>
>
>Uh, createdb and CREATE DATABASE both have encoding options.  initdb
>only sets the encoding for template1, and the default for future
>databases, but you can override it.
>
>  
>

That is true for encoding, but not true for LC_CTYPE and LC_COLLATE 
locale settings, which only initdb can set.

cheers

andrew