Need magic for identifieing double adresses - Mailing list pgsql-general

From Andreas
Subject Need magic for identifieing double adresses
Date
Msg-id 4C9183AA.1060906@gmx.net
Whole thread Raw
Responses Re: Need magic for identifieing double adresses  (Darren Duncan <darren@darrenduncan.net>)
Re: Need magic for identifieing double adresses  (Gary Chambers <gwchamb@gmail.com>)
Re: Need magic for identifieing double adresses  (Sam Mason <sam@samason.me.uk>)
Re: Need magic for identifieing double adresses  (Bill Thoen <bthoen@gisnet.com>)
Re: Need magic for identifieing double adresses  (John DeSoi <desoi@pgedit.com>)
List pgsql-general
  Hi,

I need to clean up a lot of contact data because of a merge of customer
lists that used to be kept separate.
I allready know that there are double entries within the lists and they
do overlap, too.

Relevant fields could be  name, street, zip, city, phone

Is there a way to do something like this with postgresql ?

I fear this will need still a lot of manual sorting and searching even
when potential peers get automatically identified.


Regards
Andreas

pgsql-general by date:

Previous
From: "Frank Ch. Eigler"
Date:
Subject: Re: Getting FATAL: terminating connection due to administrator command
Next
From: Darren Duncan
Date:
Subject: Re: Need magic for identifieing double adresses