Skip site navigation (1) Skip section navigation (2)

Unable to use COPY..FROM with NULL numeric fields

From: "Nikh Nath" <nnath(at)westlakefinancial(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Unable to use COPY..FROM with NULL numeric fields
Date: 2002-10-30 00:34:55
Message-ID: E936C9C6709EF340B2B00D779FD59CF703BE2D2D@nowexchange.HANKEYINVESTMENTS.COM (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)westlakefinancial(dot)com 

Responses

pgsql-novice by date

Next:From: eric soroosDate: 2002-10-30 01:02:28
Subject: Re: Unable to use COPY..FROM with NULL numeric fields
Previous:From: Nikh NathDate: 2002-10-30 00:31:20
Subject: Unable to use COPY..FROM with NULL numeric fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group