Re: Proposal: new pg_dump options --copy-delimiter and

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: Proposal: new pg_dump options --copy-delimiter and
Дата
Msg-id
87irs5s4yu.fsf@stark.xeocode.com
Ответ на
Список
Дерево обсуждения
Proposal: new pg_dump options --copy-delimiter and --copy-null David Fetter <david@fetter.org>
Re: Proposal: new pg_dump options --copy-delimiter and --copy-null Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: new pg_dump options --copy-delimiter and --copy-null David Fetter <david@fetter.org>
Re: Proposal: new pg_dump options --copy-delimiter and --copy-null Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: new pg_dump options --copy-delimiter and --copy-null Bruce Momjian <pgman@candle.pha.pa.us>
Re: Proposal: new pg_dump options --copy-delimiter and "Joshua D. Drake" <jd@commandprompt.com>
Re: Proposal: new pg_dump options --copy-delimiter and Greg Stark <gsstark@mit.edu>
Re: Proposal: new pg_dump options --copy-delimiter and Andrew Dunstan <andrew@dunslane.net>
Re: Proposal: new pg_dump options --copy-delimiter and Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: new pg_dump options --copy-delimiter and Andrew Dunstan <andrew@dunslane.net>
Re: Proposal: new pg_dump options --copy-delimiter and Tom Lane <tgl@sss.pgh.pa.us>
Re: Proposal: new pg_dump options --copy-delimiter and Andrew Dunstan <andrew@dunslane.net>
Re: Proposal: new pg_dump options --copy-delimiter and Greg Stark <gsstark@mit.edu>
Re: Proposal: new pg_dump options --copy-delimiter and David Fetter <david@fetter.org>

Tom Lane  writes:

> Andrew Dunstan  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 по дате отправления
От: Andrew Dunstan
Дата:
От: Matthew T. O'Connor
Дата:
FAQ