yes now i can do the copy after replace comma delimiter with tab delimiter which is default copy with delimiter . btw i've another question : how do we run the COPY command from file which has several null columns in each field. thanks.
example :
dwnc=# copy biosadm.custinv_temp dwnc-# from '/home/bios/customer_data/CustomerInvoice_5Dec03_tab.txt' ; ERROR: copy: line 1, Missing data for column "subsidiary"
p/s: my subsidiary column has several null data.
"Gregory S. Williamson" <gsw@globexplorer.com>
07:06 PM PST Yesterday
To: <azwa@nc.com.my>, <pgsql-sql@postgresql.org> cc: Subject: RE: [SQL] COPY command
This sounds as if the last character in each line might be a delimiter (a ",") which is standard for data unloaded from some sources; if this is the case try removing it and your data should load. Or you may have a comma in a character field and that is throwing off the count for the line in question ?
