Re: [GENERAL] use of column in COPY

2008-08-01 Thread David Wilson
On Fri, Aug 1, 2008 at 10:16 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[GENERAL] use of column in COPY

2008-08-01 Thread Ivan Sergio Borgonovo
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?

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general