Re: Ragged CSV import - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Ragged CSV import
Date
Msg-id 4AA86722.1070203@dunslane.net
Whole thread Raw
In response to Re: Ragged CSV import  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Ragged CSV import
Re: Ragged CSV import
List 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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: CommitFest 2009-09 Plans and Call for Reviewers
Next
From: Robert Haas
Date:
Subject: Re: Ragged CSV import