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
ique Alves Lima" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 10, 2004 11:00 PM Subject: [SQL] About pg_dump > Hi, everybody ! > > I don't know if this is the best list to ask this question but if it > doesn't, please forgive me (

[SQL] About pg_dump

2004-03-10 Thread Daniel Henrique Alves Lima
Hi, everybody ! I don't know if this is the best list to ask this question but if it doesn't, please forgive me (should i try pgsl-general, maybe ?)... We have a postgresql database in production and i've 2 questions about pg_dumpall boring me. We "dump" both ddl and data as SQL command