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 <[EMAIL PROTECTED]>
01/09/2004 06:54 PM ZE9 | To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED] Subject: Re: [SQL] Missing data for column |
On Jan 9, 2004, at 4:15 PM, [EMAIL PROTECTED] 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.
Regards,
Michael Glaesemann
grzm myrealbox com
