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