Re: Ragged CSV import

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Ragged CSV import
Дата
Msg-id 1252571049.9102.0.camel@fsopti579.F-Secure.com
обсуждение исходный текст
Ответ на Re: Ragged CSV import  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Ragged CSV import  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Wed, 2009-09-09 at 19:18 -0400, Robert Haas wrote:
> I agree that ignoring extra columns is a bad idea, but I don't even
> like the idea of ignoring missing columns.  It doesn't seem like a
> good idea to take a spreadsheet and feed it into COPY without doing
> any validation anyway, and this is the kind of thing that is trivial
> to clean up with a thin layer of Perl or your scripting language of
> choice.

I would think that a spreadsheet application has some kind of control
over its export format, too.  Perhaps you can just tell it to export
only the first N columns?



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

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: logging hook for database audit
Следующее
От: Nikhil Sontakke
Дата:
Сообщение: Re: Ragged CSV import