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