Re: Apparent Problem With NULL in Restoring pg_dump - Mailing list pgsql-general

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