This topic describes the extensions that are supported by Apsara PolarDB. Apsara PolarDB is compatible with Oracle.

Apsara PolarDB continuously updates its kernel to support new extensions or extension versions. To view the supported extensions, run the following statement:
show polar_supported_extensions;
To view your kernel version, run the following statement:
show polar_release_date;

The following table describes the extensions that are supported by kernel version 20191030. The table also lists the latest extension versions.

ExtensionLatest versionDescriptionCompatible extensionLatest version
appendchildxml0.0.1Appends a user-supplied value onto the target XML. The value functions as the child of the node that is indicated by an XPath expression.N/AN/A
btree_gin1.3Provides general-purpose Generalized Inverted Indexes (GINs).N/AN/A
btree_gist1.5Provides general-purpose Generalized Search Tree (GiST) indexes.N/AN/A
citext1.5Provides a case-insensitive character string type.N/AN/A
cube1.4Provides a data type that represents multidimensional cubes.N/AN/A
dict_int1.0Provides a dictionary template for full-text search. The dictionary template is designed for number indexing.N/AN/A
earthdistance1.1Provides two methods of calculating great circle distances on the surface of the Earth.N/AN/A
fuzzystrmatch1.1Provides functions that determine the similarities between strings.N/AN/A
hstore1.5Provides a data type that can be used to store sets of key-value pairs.N/AN/A
index_advisor1.0Provides index recommendations.N/AN/A
intagg1.1Provides an enumerator and integer aggregator.N/AN/A
intarray1.2Provides functions and operators that manipulate linear arrays. You can also perform indexed searches by using specific operators.N/AN/A
isn1.2Provides data types for the international product numbering standards.N/AN/A
ltree1.1Provides a data type for the data that is stored in a hierarchical tree-like structure.N/AN/A
pg_buffercache1.3Provides a method of checking the shared buffer cache in real time.N/AN/A
pg_prewarm1.2Provides an easy way to perform prewarming on table data.N/AN/A
pg_stat_statements1.6Provides a method of tracking the statistics of all SQL statements that have been executed.N/AN/A
pg_trgm1.4Provides functions and operators that determine the similarities of ASCII alphanumeric text. The similarities are determined based on trigram matching.N/AN/A
pg_wait_sampling1.1Collects the sampling data of wait events.N/AN/A
pgcrypto1.3Provides cryptographic functions.N/AN/A
pgrowlocks1.2Provides a function that returns row locking information for a specified table.N/AN/A
pgstattuple1.5Provides functions that return tuple-level statistical data.N/AN/A
plperl1.0Provides the PL/Perl procedural language that can be used to create functions.N/AN/A
plpgsql1.0Provides the PL/pgSQL procedural language that can be used to create functions.N/AN/A
pltcl1.0Provides the PL/Tcl procedural language that can be used to create functions.N/AN/A
polar_anydata1.0Provides the ANYDATA data type.N/AN/A
polar_gtt1.0Provides functions that can be used to manage global temporary tables.N/AN/A
sqlprotect1.0Provides the SQL firewall feature.N/AN/A
sslinfo1.2Provides the information about the SSL certificate that is provided by the current client.N/AN/A
tablefunc1.0Supports functions that return tables, such as the crosstab function.N/AN/A
unaccent1.1Provides a text search dictionary that removes diacritic signs from lexemes.N/AN/A
uuid-ossp1.1Provides functions that generate universally unique identifiers (UUIDs).N/AN/A
polar_cyclechecker_noticer1.0Reports an error if the result set of the CONNECT BY multi-clause contains cycle data.N/AN/A
ganos_geometry2.3Provides geography and geometry data types.postgis2.5.0
ganos_raster2.3Provides geographic raster data types.postgis2.5.0
ganos_geometry_sfcgal2.3Creates geometry 3D models.postgis_sfcgal2.5.0
ganos_geometry_topology2.3Creates a geometry topology.postgis_topology 2.5.0
ganos_tiger_geocode2.3Provides the TIGER geocoding service.postgis_tiger_geocode2.5.0
ganos_address_standardizer2.3Provides the address standardization service.address_standardizer 2.5.0
ganos_address_standardizer_data_us2.3Provides the address standardization service. You can use this extension to format and standardize American addresses.address_standardizer_data_us 2.5.0
ganos_networking2.3Finds the optimal path in a geometric network diagram.pgrouting2.6.2
ganos_pointcloud2.3Provides data storage and computing services for the point cloud.N/AN/A
ganos_trajectory2.3Provides data types for moving objects.N/AN/A