Re: using the difference function - Mailing list pgsql-novice

From Joshua Tolley
Subject Re: using the difference function
Date
Msg-id 20090625204857.GJ16838@eddie
Whole thread Raw
In response to using the difference function  ("SMITH, Phillip \(external\)" <phillip.smith@astrium.eads.net>)
List pgsql-novice
On Thu, Jun 25, 2009 at 06:07:22PM +0100, SMITH, Phillip (external) wrote:
>    I have installed PostgreSQL 8.3 using a windows exe. Looking under
>    C:\Program Files\PostgreSQL\8.3\lib i can see fuzzystrmatch.dll.
>
>    However it is not in the bin folder.
>    Is this function considered a bolt-on to PostgreSQL and if so:
>    1.  How do I install it?

I don't do windows, so can't tell you exactly, but there should be a
fuzzystrmatch.sql file somewhere there as well. Run that SQL script, i.e.
     psql -f fuzzystrmatch.sql database_name

>    2. Does it install to the server or to each database?

You'll need to run that install script in each database where you'd like to
have fuzzystrmatch functions available. Alternatively, run it in the template1
database before creating the databases you want it used in, and it will be
automatically installed in each database.

- Josh / eggyknap

Attachment

pgsql-novice by date:

Previous
From: "SMITH, Phillip \(external\)"
Date:
Subject: using the difference function
Next
From: Ruzsinszky Attila
Date:
Subject: Duplicated records deleting between some secs