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

From Alvaro Herrera
Subject Re: Nasty, propagating POLA violation in COPY CSV HEADER
Date
Msg-id 1340216405-sup-3419@alvh.no-ip.org
Whole thread Raw
In response to Re: Nasty, propagating POLA violation in COPY CSV HEADER  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Excerpts from Andrew Dunstan's message of mié jun 20 12:56:52 -0400 2012:
>
> 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.

Ah, great, thanks.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [ADMIN] pg_basebackup blocking all queries with horrible performance
Next
From: Robert Haas
Date:
Subject: Re: Too frequent message of pgbench -i?