Re: Ragged CSV import - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Ragged CSV import
Date
Msg-id 1252571049.9102.0.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to Re: Ragged CSV import  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Ragged CSV import
List 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 by date:

Previous
From: Itagaki Takahiro
Date:
Subject: logging hook for database audit
Next
From: Nikhil Sontakke
Date:
Subject: Re: Ragged CSV import