Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY from .csv File and Remove Duplicates [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: COPY from .csv File and Remove Duplicates [RESOLVED]
Date
Msg-id alpine.LNX.2.00.1108121544250.25454@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: COPY from .csv File and Remove Duplicates  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: Kudos
Next
From: "David Johnston"
Date:
Subject: Bit-Strings - Is there a more succinct way to do this?