| 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
| 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? |