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 87oe1xsfos.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Proposal: new pg_dump options --copy-delimiter and  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Proposal: new pg_dump options --copy-delimiter and  (Andrew Dunstan <andrew@dunslane.net>)
Re: Proposal: new pg_dump options --copy-delimiter and  (David Fetter <david@fetter.org>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:

> David I don't get this... what are you copying from/to that would
> wouldn't just script? If you throw into a script you can change
> the delimiter on the fly using translation.

I think what he's getting at is for things like, say, a contrib package with a
README that includes an example. He wants to be able to say "just paste these
commands into psql".

The problems are a) there's no guarantee the data is safe to put through your
hypothetical tab-destroying copy/paste anyways. There could be tabs or other
unsafe characters in the data. b) We have no way of knowing which characters
are or aren't safe in your hypothetical copy/paste system. Why is tab unsafe
in the first place?

Personally I find anything that would encourage people to use anything other
than tabs evil anyways. All those people who think | is somehow a reasonable
choice or want to use commas and then get all confused trying to escape them
and invent ever more confused syntaxes for escaping the escape characters.
Just use tab separated data like man was meant to.

-- 
greg



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Adding a --quiet option to initdb
Next
From: Andrew Dunstan
Date:
Subject: Re: Proposal: new pg_dump options --copy-delimiter and