Re: Nasty, propagating POLA violation in COPY CSV HEADER - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Nasty, propagating POLA violation in COPY CSV HEADER
Date
Msg-id 4FE200D4.9050706@dunslane.net
Whole thread Raw
In response to Re: Nasty, propagating POLA violation in COPY CSV HEADER  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Nasty, propagating POLA violation in COPY CSV HEADER
List pgsql-hackers

On 06/20/2012 12:50 PM, Alvaro Herrera wrote:
> Another related case: you have a file with headers and columns (n, t, 
> x, y, z) but your table only has n and t. How would you tell COPY to 
> discard the junk columns? Currently it just complains that they are 
> there. 


That's one of the main use cases for file_text_array_fdw.

cheers

andrew


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Nasty, propagating POLA violation in COPY CSV HEADER
Next
From: Simon Riggs
Date:
Subject: Re: [PATCH 10/16] Introduce the concept that wal has a 'origin' node