Ya Abhijeet, I removed '\0001' so its working fine but still the issue is database id field as till I pass the *id* parameter value in the data file it works well but I can't hold of the id value and unlike Mysql, Postgres don't even support null values which can be passed for the auto increment value.
On Mon, Jan 21, 2013 at 5:23 PM, abhijeet gaikwad <[email protected]>wrote: > Your fields are terminated by comma. Your command directs otherwise - > '\0000'. > > Thanks, > Abhijeet > On Jan 21, 2013 2:13 PM, "Vineet Mishra" <[email protected]> > wrote: > >> >> On Mon, Jan 21, 2013 at 2:08 PM, abhijeet gaikwad <[email protected] >> > wrote: >> >>> and table sche >> >> >> Ya sure, >> here is the data rows, >> >> 28.00,10005,\0001 >> 403.71,90210,\0001 >> >> I even tried with single inverted values, but not positivity. >> >> and this is the Table Schema, >> >> * Column | Type | Modifiers | Storage | Description >> --------+--------------+-----------+---------+------------- >> volume | numeric(8,2) | | main | >> zip | integer | | plain | >> * >> >> >> -- >> Thanks and Regards >> Vineet Mishra >> > -- Thanks and Regards Vineet Mishra
