how to install fuzzystrmatch.sql pg_trgm.sql on postgresql on mac os x

Question

I have installed postgresql according to this, but I also need fuzzy string match functions, but I have no idea how to install these.

Answer 1

For the Mac, the .sql files are in a folder such as /Library/PostgreSQL/8.3/share/postgresql/contrib

Answer 2

Usually with a sql file full of functions, it is something like this:

cat fuzzystrmatch.sql | psql {database name}