Re: Add switches for DELIMITER and NULL in pg_dump COPY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Add switches for DELIMITER and NULL in pg_dump COPY
Дата
Msg-id 14919.1141833780@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Add switches for DELIMITER and NULL in pg_dump COPY  (David Fetter <david@fetter.org>)
Ответы Re: Add switches for DELIMITER and NULL in pg_dump COPY  (David Fetter <david@fetter.org>)
Список pgsql-hackers
David Fetter <david@fetter.org> writes:
> From the earlier discussion, it appears that there is a variety of
> opinions on what the COPY delimiter should be in pg_dump.  This patch
> allows people to set it and the NULL string.

Did anyone provide a convincing use case for this?  It's of zero value
from the perspective of pg_dump itself; the only possible argument is
that it makes it easier for program-foo to parse the output of pg_dump.
But I don't see any programs around to parse arbitrary SQL scripts,
especially not the pretty-PG-specific scripts that pg_dump emits.

I think it much more likely that people needing this sort of thing would
be using something like "psql -c 'copy foo to stdout'", so as to get the
data without any added overhead.

So this seems like mere creeping featurism to me.  pg_dump has too many
switches already.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Interval subtracting
Следующее
От: Neil Conway
Дата:
Сообщение: Re: [PATCHES] Add switches for DELIMITER and NULL in pg_dump COPY