How to Install and Uninstall Fuzzy String Matching

Products

• VMware Tanzu Greenplum

Issue/Introduction

The fuzzy string is a Pivotal Greenplum match function Extension based on the PostgreSQL fuzzystrmatch module. This article describes how to install Fuzzy String Match on a Pivotal Greenplum database. 

 

Environment

Resolution

Run the following SQL script to install the function on a Pivotal Greenplum database.

psql -d <database-name> -f $GPHOME/share/postgresql/contrib/fuzzystrmatch.sql

Run the following SQL script to uninstall the functions.

psql -d <database-name> -f $GPHOME/share/postgresql/contrib/uninstall_fuzzystrmatch.sql

Additional Information

For further information, refer to thl Reference Guide at the following location: https://docs.vmware.com/en/VMware-Greenplum/5/greenplum-database/ref_guide-extensions-fuzzystrmatch.html 

+ Environment:

Pivotal Greenplum all versions