Re: COPY from .csv File and Remove Duplicates [RESOLVED]

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY from .csv File and Remove Duplicates [RESOLVED]
Date: 2011-08-12 22:46:58
Message-ID: alpine.LNX.2.00.1108121544250.25454@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 12 Aug 2011, David Johnston wrote:

> Thus, you need to replace the "*" in the SELECT with the specific columns
> that correspond to the columns listed in to INSERT portion of the query.

David,

Mea culpa! I should have seen this myself. Now the query works and I have
about 6K duplicate pairs to fix.

Thanks,

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-08-12 23:42:24 Bit-Strings - Is there a more succinct way to do this?
Previous Message Greg Smith 2011-08-12 20:40:16 Re: Postgres on SSD