Joseph Shraibman wrote:
> Barry Lind wrote:
>> Joseph Shraibman wrote:
>>> I notice there is no way to change a database's encoding. If I just
>>> change the encoding type in the pg_database to latin1 will there be
>>> data loss?
>>
>>
>>
>> The recommended way to do this would be to dump the contents of the
>> database, create a new database with the desired character set and
>> then import the data into that new database. I don't know if changing
>> pg_database directly would work or not.
>>
>>
> That didn't work.
Acutally it did. My test data was flawed. What didn't work is editing the dump to change
the type to unicode.