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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal: new pg_dump options --copy-delimiter and --copy-null
Дата
Msg-id 26997.1138331825@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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  (David Fetter <david@fetter.org>)
Список pgsql-hackers
David Fetter <david@fetter.org> writes:
> I have seed database scripts quasi-generated from pg_dump which
> include COPY statements, but the data is hard to edit (especially cut
> & paste operations) when the COPY delimiter is some non-visible
> character like \t.

This seems like an awfully weak use-case for adding to pg_dump's already
overly complicated feature set.  The difficulty of parsing COPY output
is not simplified by making the delimiter variable --- more likely the
reverse.  Furthermore, it's quite unclear why you'd use pg_dump at all
to generate a data file that you intend to feed to some other program.
Seems to me that "psql -c 'COPY ...'" is a more likely front-end for
such a process.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Proposal: new pg_dump options --copy-delimiter and --copy-null
Следующее
От: David Fetter
Дата:
Сообщение: Re: Proposal: new pg_dump options --copy-delimiter and --copy-null