Pivotal Knowledge Base

Follow

HowTo - Install / Uninstall Fuzzy String Matching

Environment

Product Version
Greenplum All Versions

Purpose

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. 

Procedure

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 the Pivotal Reference Guide at the following location: Pivotal Greenplum database > Reference Guide

Comments

Powered by Zendesk