Re: Missing data for column

<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 />