Re: Ragged CSV import - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Ragged CSV import
Date
Msg-id 6283.1252608562@sss.pgh.pa.us
Whole thread Raw
In response to Re: Ragged CSV import  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Ragged CSV import
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> An easy fix for that is to allow this form of COPY to return text[]
>> instead of a fixed number of text columns.

> I'd like to see some concrete syntax suggestions for such an animal.

I think there were some in the previous discussion --- it came down
to using a SRF with arguments that specify the copy source and options.
Setting the result type as text[] instead of some has-to-be-specified
composite type should actually make it a bit easier.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: RfD: more powerful "any" types
Next
From: Tom Lane
Date:
Subject: Re: Ragged CSV import