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

Re: 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: Re: Unable to use COPY..FROM with NULL numeric fields
Date: 2002-10-30 01:39:00
Message-ID: E936C9C6709EF340B2B00D779FD59CF703BE2D67@nowexchange.HANKEYINVESTMENTS.COM (view raw or flat)
Thread:
Lists: pgsql-novice
That changed the error message to :

megasys=# COPY acct FROM '/home/megasys/acct.dmp.new' USING DELIMITERS
'\t' WITH NULL AS '\\N';
ERROR:  copy: line 1, Bad numeric input format ''

Thanks
Nikh Nath

-----Original Message-----
From: eric soroos [mailto:eric-psql(at)soroos(dot)net] 
Sent: Tuesday, October 29, 2002 5:02 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Unable to use COPY..FROM with NULL numeric fields


On Tue, 29 Oct 2002 16:34:55 -0800 in message
<E936C9C6709EF340B2B00D779FD59CF703BE2D2D(at)nowexchange(dot)HANKEYINVESTMENTS(dot)
COM>, "Nikh Nath" <nnath(at)westlakefinancial(dot)com> wrote:
> 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'
> 

Try: 

	COPY acct FROM '/home/megasys/acct.dmp.new' USING DELIMITERS
'\t' WITH NULL AS '\\N';
 
eric



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

pgsql-novice by date

Next:From: Kirby KruegerDate: 2002-10-30 02:10:50
Subject: Working with timestamps and Unix Time
Previous:From: eric soroosDate: 2002-10-30 01:02:28
Subject: Re: Unable to use COPY..FROM with NULL numeric fields

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