Re: Apparent Problem With NULL in Restoring pg_dump

On Thu, 15 Sep 2011, Andy Colson wrote:

> Trim it up:
> andy=# select '['|| rtrim(trim(trailing E'\n' from a)) || ']' from junk;

Andy,

Scrolling through the table with rows ordered by date and chemical I find
no duplicates ... so far. However, what I do find is that the above did not
work:

GW-22 | 1998-12-16 | Zinc | 0.01
GW-22 | 1998-12-16 | pH | 7.83
GW-22 +| 1999-03-09 | Alkalinity, Bicarbonate | 97
| | |
GW-22 +| 1999-03-09 | Alkalinity, Total | 80
| | |
GW-22 +| 1999-03-09 | Aluminum | 0.01
| | |
GW-22 +| 1999-03-09 | Antimony |

As my previous message noted, selecting rows with two spaces before the
newline returned 0 rows.

I'll continue looking for duplicates, but I suspect there are none. I just
need to get rid of the newlines, drop all rows for site_id from the
chemistry table, then insert the cleaned rows from the junk table.

Regards,

Rich