Re: Proposal: new pg_dump options --copy-delimiter and - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Proposal: new pg_dump options --copy-delimiter and
Date
Msg-id 87irs5s4yu.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Proposal: new pg_dump options --copy-delimiter and  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Andrew Dunstan <andrew@dunslane.net> writes:
> > On Fri, 2006-01-27 at 13:43 -0500, Tom Lane wrote:
> >> That line of argument leads to the suggestion that pg_dump should just
> >> use something else (I'd vote for "|"), all the time, in order to produce
> >> more robust dump files.  I still don't see the argument for exposing
> >> a switch though.
> 
> > If we regard them as suitable for human editing for normal use, yes.
> 
> No, that actually was no part of my point.  A pg_dump file that doesn't
> use tabs is more likely to survive being emailed, for instance.  

Except it's not at all. It's perhaps more likely to load but load incorrectly
though. There's no guarantee there aren't tabs in the data for example. Or
once we start being this paranoid, there's no guarantee that some other
character won't survive.

The only place this line of argument ends up is with pg_dump automatically
base64 encoding its entire output.

-- 
greg



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Proposal: new pg_dump options --copy-delimiter and
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: stats for failed transactions (was Re: [GENERAL] VACUUM