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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Kirby Krueger | 2002-10-30 02:10:50 | Working with timestamps and Unix Time |
Previous Message | eric soroos | 2002-10-30 01:02:28 | Re: Unable to use COPY..FROM with NULL numeric fields |