PolarDB:Supported extensions

Extension name

Oracle syntax compatibility 2.0

Oracle syntax compatibility 1.0

Description

address_standardizer

3.3.7

3.3.4

Provides address standardization and calculation.

address_standardizer_data_us

3.3.7

3.3.4

U.S. Address Standardization

bloom

1.0

1.0

Provides an index access method based on Bloom filters.

btree_gin

1.3.1

1.3

Provides a sample GIN operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

btree_gist

1.6.1

1.5

Provides a sample GiST operator class that implements B-tree equivalent behavior for multiple data types and all enum types.

citext

1.6

1.5

Provides a case-insensitive string type.

cube

1.5

1.4

Provides a data type to represent multidimensional cubes.

decoderbufs

0.1.0

0.1.0

Outputs data that is compatible with the Debezium platform based on the Protocol Buffers protocol.

dict_int

1.0

1.0

A sample full-text search dictionary template.

earthdistance

1.1

1.1

Provides two different methods to calculate the great-circle distance on the surface of the Earth.

fuzzystrmatch

1.1

1.1

Determines the similarity and distance between strings.

ganos_address_standardizer

7.4

6.8

A toponym standardization extension based on the PAGC standard.

ganos_address_standardizer_data_us

7.4

6.8

A U.S. data extension for toponym standardization based on the PAGC standard.

ganos_geometry

7.4

6.8

Provides computing and analysis features for spatial geometry types.

ganos_geometry_pyramid

7.4

6.8

Used for fast display of 2D spatial geometry big data.

ganos_geometry_sfcgal

7.4

6.8

Provides extension features for the spatial geometry sfcgal extension.

ganos_geometry_topology

7.4

6.8

Provides computing and analysis features for spatial geometry types.

ganos_networking

7.4

6.8

Provides computing and analysis features for spatial geometry network types.

ganos_pointcloud

7.4

6.8

Provides storage, computing, and analysis features for point clouds.

ganos_pointcloud_geometry

7.4

6.8

Provides storage, computing, and analysis features for point clouds.

ganos_raster

7.4

6.8

Provides storage, computing, and analysis features for spatial raster data.

ganos_spatialref

7.4

6.8

Provides computing and analysis features for spatial references.

ganos_tiger_geocoder

7.4

6.8

Provides support for USCB TIGER data types.

ganos_trajectory

7.4

6.8

Provides computing and analysis features for Ganos moving object data (MOD).

hll

2.17

2.17

Quickly estimates business metrics such as page views (PVs) and unique visitors (UVs).

hstore

1.8

1.5

Stores key-value pairs within a single PostgreSQL value.

hypopg

1.4.0

1.3.1

Creates hypothetical indexes.

imgsmlr

1.0

-

Supports similar image search.

intagg

1.1

1.1

Provides an integer aggregator and an enumerator.

intarray

1.5

1.2

Provides useful functions and operators to manipulate integer arrays that do not contain null values.

isn

1.2

1.2

Validates input against a hard-coded prefix list and is also used to concatenate numbers on output.

ltree

1.2

1.1

Used to represent labels of data stored in a hierarchical tree-like structure.

oss_fdw

1.1

1.1

Reads and writes data in OSS.

pase

0.0.1

0.0.1

Efficient vector search.

pg_bigm

1.2

1.2

Creates a bigram (2-gram) GIN index to accelerate the full-text search process.

pg_buffercache

1.5

1.3

Provides a method to inspect the shared buffer in real time.

pg_freespacemap

1.2

1.2

Examines the free space map (FSM).

pg_jieba

1.1.0

1.1.0

Performs tokenization for Chinese full-text search.

pg_hint_plan

1.4.1

1.3.7

Uses hints in special comment statements to make PostgreSQL change its execution plan.

pg_prewarm

1.2

1.2

Provides a convenient way to load data into the operating system buffer or the PostgreSQL buffer.

pg_sphere

1.0

1.0

Provides spherical data types, functions, operators, and indexes for PostgreSQL.

pg_stat_statements

1.9.2

1.6

Provides a method to track the execution statistics of all SQL statements that are executed by the server.

pg_trgm

1.6

1.4

Provides functions and operators to determine the similarity of alphanumeric text, and index operator classes that support fast search for similar strings.

pgAudit

1.6.2

1.3.3

Provides detailed session and object audit logging.

pgcrypto

1.3

1.3

Provides cryptographic functions for PostgreSQL.

pgrouting

3.4.2

3.4.2

Provides computing and analysis features for spatial geometry networks.

pgrowlocks

1.2

1.2

Provides a function to display row lock information for a specified table.

pgstattuple

1.5

1.5

Provides multiple functions to obtain tuple-level statistics.

PGVector

0.8.0

0.5.0

An extension for high-dimensional vector similarity search.

pldebugger

1.1

1.1

A stored procedure debugging extension.

plperl

1.0

1.0

Provides the Perl procedural language.

plpgsql

1.0

1.0

Provides the SQL procedural language.

pltcl

1.0

1.0

Provides the Tcl procedural language.

postgis

3.3.7

3.3.4

PostGIS extensions for spatial and geographic information.

postgis_sfcgal

3.3.7

3.3.4

PostGIS SFCGAL extensions for spatial and geographic information.

postgis_tiger_geocoder

3.3.7

3.3.4

PostGIS TIGER data extensions for spatial and geographic information.

postgis_topology

3.3.7

3.3.4

PostGIS topology data extensions for spatial and geographic information.

roaringbitmap

0.5

0.6

Uses the bitmap feature to improve query performance.

rum

1.3

-

High-speed full-text search.

sequential_uuid

1.0.2

1.0.2

A UUID generator with a sequential pattern.

smlar

1.0

1.0

Calculates the similarity between two arrays of the same type.

sslinfo

1.2

1.2

Provides information about the SSL certificate that is provided by the current client.

tablefunc

1.0

1.0

Multiple table-returning functions are included.

tsm_system_rows

1.0

1.0

Provides the SYSTEM_ROWS table sampling method.

tsm_system_time

1.0

1.0

Provides the SYSTEM_TIME table sampling method.

unaccent

1.1

1.1

A text search dictionary that removes accents (diacritical marks) from lexemes.

uuid-ossp

1.1

1.1

Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms.

varbitx

1.1

1.0

Supports multiple bit operations.

PGVector

0.8.0

0.5.0

An extension for high-dimensional vector similarity search

wal2json

2.6

2.5

Outputs logical log files in JSON format.

xml2

1.1

1.1

Provides XPath query and XSLT features.

zhparser

1.0

1.0

Chinese full-text search.

zombodb

-

4.0

Powerful text indexing and analysis features.