Re: use of column in COPY

From: "David Wilson" <david(dot)t(dot)wilson(at)gmail(dot)com>
To: "Ivan Sergio Borgonovo" <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: use of column in COPY
Date: 2008-08-01 15:31:20
Message-ID: e7f9235d0808010831vc3b0db2le828342a37e7d022@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 1, 2008 at 10:16 AM, Ivan Sergio Borgonovo
<mail(at)webthatworks(dot)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(dot)t(dot)wilson(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Linos 2008-08-01 16:30:36 savepoint problems
Previous Message Tom Lane 2008-08-01 15:08:32 Re: eliminating records not in (select id ... so SLOW?