Re: [GENERAL] v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8

2008-02-26 Thread Tom Lane
Ralph Smith <[EMAIL PROTECTED]> writes: > I'm not sure if you're saying I should ignore these errors... No, not at all. > I'm using dumps from DB airaburst. Doesn't look like that --- you have > Name| Owner | Encoding > +--+--- > airburst | root |

Re: [GENERAL] v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8

2008-02-26 Thread Ralph Smith
I'm not sure if you're saying I should ignore these errors... I'm using dumps from DB airaburst. >postgres=# \l List of databases Name| Owner | Encoding +--+--- airburst | root | SQL_ASCII lt_dev1| postgres | UTF8 lt_dev2| postgre

Re: [GENERAL] v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8

2008-02-24 Thread Dean Gibson (DB Administrator)
On 2008-02-22 17:57, Ralph Smith wrote: I'm looking at the v7.4 manuals and I don't see how to encode for importing into a v8 DB using UTF8. Maybe I'm making this hard on myself? The old DB is using SQL_ASCII. We'd like the new one to use UTF8. As development proceeds, I'm going to have to do

[GENERAL] v7.4 pg_dump(all) need to encode from SQL_ASCII to UTF8

2008-02-24 Thread Ralph Smith
I'm looking at the v7.4 manuals and I don't see how to encode for importing into a v8 DB using UTF8. Maybe I'm making this hard on myself? The old DB is using SQL_ASCII. We'd like the new one to use UTF8. As development proceeds, I'm going to have to do this regularly, both the entire DB and