Pivotal Knowledge Base

Follow

How to Install and Uninstall Fuzzy String Matching

Environment

Pivotal Greenplum all versions

Purpose

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. 

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