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