Sorry for the late respond. i've solved my problem. the error comes out when the data has subsidiary column but there is no subsidiary column in table. tq
Michael Glaesemann <grzm@myrealbox.com>
01/09/2004 06:54 PM ZE9
To: azwa@nc.com.my cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Missing data for column
On Jan 9, 2004, at 4:15 PM, azwa@nc.com.my wrote:
> Hi, > > i got an error below after running copy command . the table structure > as > following : > > Table "biosadm.custinv_temp > Column | Type | > -------------+---------------+- > yr | integer | > custname | text | > invstatus | text | > custlo | text | > invno | integer | > invdate | date | > amount | numeric(10,2) | > acc | text | > salesperson | text | > > ERROR: copy: line 1, Missing data for column "subsidiary"
Could you include the COPY command you're using, as well as the first couple of lines of the file you're copying from? It's hard to know what the problem is without this.
