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: Nikh Nath||Date: 2002-10-30 00:34:55|
|Subject: Unable to use COPY..FROM with NULL numeric fields|
|Previous:||From: Thorsten Haude||Date: 2002-10-29 20:38:30|