Re: [SQL] About pg_dump

2004-03-11 Thread Daniel Henrique Alves Lima
I've made a test and it seems ok to me. I'm using utf-8 encoding under postgresql 7.3.3. Tom Lane wrote: "Rute Solipa" <[EMAIL PROTECTED]> writes: it seems that the pg_dump command doesn't keep the encoding information. As of 7.4.2 it does emit a SET client_encoding. In prior release

Re: [SQL] About pg_dump

2004-03-11 Thread Tom Lane
"Rute Solipa" <[EMAIL PROTECTED]> writes: > it seems that the pg_dump command doesn't keep the encoding information. As of 7.4.2 it does emit a SET client_encoding. In prior releases, if you are manually creating the destination database then you need to be careful to create it with the same enco

Re: [SQL] About pg_dump

2004-03-11 Thread Rute Solipa
hi, i had to restore a database from a pg_dump and i'm having problems with the encoding. it seems that the pg_dump command doesn't keep the encoding information. does anybody can help me resolve this problem. thanks rute - Original Message - From: "Daniel Henrique Alves Lima" <[EMAIL