Hello,

I'm trying to import a text file into a table using the COPY command.

The text file contains four columns: id, col_1, col_2, col_3 (in that order).
My target table only has id and col_1.

From the documentation I assumed that the following statement

  copy foo (id, col_1)
  from 'foo.txt'
  with (format csv, delimiter ';', header true);

would only import id and col_1, but instead it fails with "ERROR:  extra data after 
last expected column".

Am I missing something, or is this a limitation of the COPY command?

Regards
Thomas



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

Reply via email to