From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Ragged CSV import |
Date: | 2009-09-09 19:59:55 |
Message-ID: | 4AA8093B.8030206@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I have received a requirement for the ability to import ragged CSV
files, i.e. files that contain variable numbers of columns per row. The
requirement is that extra columns would be ignored and missing columns
filled with NULL. The client wanting this has wrestled with some
preprocessors to try to get what they want, but they would feel happier
with this built in. This isn't the first time I have received this
request since we implemented CSV import. People have complained on
numerous occasions about the strictness of the import routines w.r.t.
the number of columns.
I don't think that providing a CSV import mode for reading these files
will be very difficult or invasive. If it's not acceptable, I will
provide it to the client as a patch, and I will be retrofitting it to
8.4 anyway. But I think it's not an unreasonable request.
Thoughts?
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-09-09 20:13:56 | Re: Ragged CSV import |
Previous Message | Pavel Stehule | 2009-09-09 19:57:15 | Re: RfD: more powerful "any" types |