I am trying to use the following command to import a file into pgsql.
COPY acct FROM '/home/megasys/acct.dmp.new' USING DELIMITERS
'\t' WITH NULL AS '\N';
I keep getting this error.
ERROR: copy: line 1, Bad numeric input format '\N'
All the numeric fields in the table can be NULL ..
Where does the problem lie?? Cannot numeric fields be NULL in copy
I have just decided to migrate from mysql to pgsql ......and already it
seems very hard to deal with this database....
Any help will be appreciated..
Project Manager ( I.T. )
Westlake Financial Services
Work : 323.692.4129
Fax : 323.692.4129
Email : nnath(at)westlakefinancial(dot)com
pgsql-novice by date
|Next:||From: eric soroos||Date: 2002-10-30 01:02:28|
|Subject: Re: Unable to use COPY..FROM with NULL numeric fields|
|Previous:||From: Nikh Nath||Date: 2002-10-30 00:31:20|
|Subject: Unable to use COPY..FROM with NULL numeric fields|