| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Ragged CSV import |
| Date: | 2009-09-10 02:40:34 |
| Message-ID: | 4AA86722.1070203@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas wrote:
> I wonder whether it would be appropriate to do something like
> implement a method by which copy could return text[] and then one
> could write wrappers around that functionality to do this as well as
> other things.
>
It's not a function ... writing a copy() function returning text[] (or
setof text[], which would be better) in plperlu would be trivial. But it
couldn't read from stdin or be able to be fed data from a client in
copy-in mode.
And even if we have it what does the sql look like to insert the values
into some table with n columns?
Anything along these lines in C is likely to be far larger than what I
had in mind, which was a fairly minor enhancement.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-09-10 02:55:09 | Re: Ragged CSV import |
| Previous Message | Robert Haas | 2009-09-10 01:13:40 | CommitFest 2009-09 Plans and Call for Reviewers |