Thread: Unable to use COPY..FROM with NULL numeric fields

Unable to use COPY..FROM with NULL numeric fields

From

"Nikh Nath"

Date:

30 October 2002, 11:03:41

Hi,

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
command?

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..

Thanks



==================================
Nikhilesh Nath
Project Manager ( I.T. )
Westlake Financial Services
Work  : 323.692.4129
Fax   : 323.692.4129
Email : nnath@westlakefinancial.com