From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
Subject: | Re: Apparent Problem With NULL in Restoring pg_dump |
Date: | 2011-09-16 01:31:50 |
Message-ID: | 201109151831.50737.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thursday, September 15, 2011 1:17:06 pm Rich Shepard wrote:
> On Thu, 15 Sep 2011, Alban Hertroys wrote:
> > You appear to have two tabs after "Depth to Water", which would be one
> > too many.
>
> Alban,
>
> I thought that I had caught all the double tabs. Thanks for seeing this
> one.
>
> Now I'm back to the tabs-in-real-columns issue:
>
> ERROR: invalid input syntax for type real: " "
> CONTEXT: COPY chemistry, line 47364, column quant: " "
>
> and here's the referenced line:
>
> \N GW-22 2004-12-17 Calcium 9.69999981 mg/L
> \N \N \N \N
>
> Removing the extra tab between 'Calcium' and 9.69999981 produces:
>
> ERROR: invalid input syntax for type numeric: "N N"
> CONTEXT: COPY chemistry, line 47364, column northing: "N N"
>
> There must be a better way to clean this table, but I don't know what it
> is.
This is one of those things I find spreadsheets actually useful for. Do a COPY or
/copy, in CSV format from the table and import it into a spreadsheet. I find the
grid layout of a spreadsheet very useful in picking out misplaced fields.
>
> Thanks again,
>
> Rich
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | adebarros | 2011-09-16 02:43:08 | Upgrading from 9.0->9.1 Ubuntu Best Practices |
Previous Message | Aleksey Tsalolikhin | 2011-09-16 00:12:09 | multi-master replication (Was: Has Pg 9.1.0 been released today?) |