Lists: | pgsql-sql |
---|
From: | azwa(at)nc(dot)com(dot)my |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Missing data for column |
Date: | 2004-01-09 07:15:01 |
Message-ID: | OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
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"
Does anybody have an idea??? TQ
From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
---|---|
To: | azwa(at)nc(dot)com(dot)my |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Missing data for column |
Date: | 2004-01-09 09:54:11 |
Message-ID: | C6417B03-4289-11D8-9330-000A95C88220@myrealbox.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
On Jan 9, 2004, at 4:15 PM, azwa(at)nc(dot)com(dot)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.
Regards,
Michael Glaesemann
grzm myrealbox com