Re: use of column in COPY - Mailing list pgsql-general

From David Wilson
Subject Re: use of column in COPY
Date
Msg-id e7f9235d0808010831vc3b0db2le828342a37e7d022@mail.gmail.com
Whole thread Raw
In response to use of column in COPY  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
On Fri, Aug 1, 2008 at 10:16 AM, Ivan Sergio Borgonovo
<mail@webthatworks.it> wrote:
> what's the use of column in the COPY FROM syntax if I get:
>
> ERROR:  extra data after last expected column
>
> I've read:
> http://bytes.com/forum/thread424089.html
>
> but then... is there any actual use?
>

I use COPY FROM extensively; the column specification allows for cases
where the incoming file doesn't match the table's column ordering (or
if the incoming file has *fewer* columns than the table).

--
- David T. Wilson
david.t.wilson@gmail.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: eliminating records not in (select id ... so SLOW?
Next
From: Linos
Date:
Subject: savepoint problems