Re: [HACKERS] pg_dump again - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] pg_dump again
Date
Msg-id 199903151425.JAA11969@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] pg_dump again  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] pg_dump again
List pgsql-hackers
Tom, is this fixed?



> Mikhail Terekhov <terekhov@emc.com> writes:
> > It seems that pg_dump (in 6.4.2) still has a problem when quoting
> > \ and ' when these characters appears together.
> > Consider the following example:
> > ... snip ...
> > terekhov(575)~>pg_dump -d -D -f ter.db terekhov
> 
> Ah, I see the problem: pg_dump's -d/-D option doesn't do quoting of
> special characters properly --- in fact, the only thing it does do
> is double-up single quote marks.  My testing was without that option ---
> without -d or -D, pg_dump uses COPY, which quotes everything properly.
> This is probably why most people weren't seeing a problem.
> 
> I'll put this on my to-do list for 6.5, but in the meantime, I'd suggest
> not using -d or -D... a dump script with one INSERT per table row is
> horribly slow compared to COPY anyway...
> 
>             regards, tom lane
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: 6.5 beta soon
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Postgres Speed or lack thereof