AnalyticDB for PostgreSQL is developed based on the Greenplum Database and is enhanced with some in-depth extensions by Alibaba Cloud. This document introduces the extension types, and how to create or delete an extension.
AnalyticDB for PostgreSQL supports the following extensions:
PostGIS: supports geographic information data.
MADlib: supports function library on Machine Learning.
fuzzystrmatch: supports fuzzy matching of strings.
orafunc: supports some Oracle functions.
oss_ext: supports reading data from OSS.
hll: supports using the HyperLogLog algorithm to perform statistical analysis.
pljava: supports compiling user-defined functions (UDF) in PL/Java.
pgcrypto: supports encryption functions.
intarray: supports integer array-related functions, operators and indexes.
Create an extension
Run the following command to create an extension:
CREATE EXTENSION <extension name>; CREATE SCHEMA <schema name>; CREATE EXTENSION IF NOT EXISTS <extension name> WITH SCHEMA <schema name>;
You need to create the plpythonu extension before creating the MADlib extension, as shown in the following example.
CREATE EXTENSION plpythonu; CREATE EXTENSION madlib;
Delete an extension
Run the following command to delete an extension:
DROP EXTENSION <extension name>; DROP EXTENSION IF EXISTS <extension name> CASCADE;