A reference list of supported extensions and versions - PolarDB

PolarDB for Oracle supports PostgreSQL extensions out of the box. To view the extensions available on your instance, run:

show polar_supported_extensions;

To check your current kernel version, run:

show polar_release_date;

The list of supported extensions is updated with each kernel release. The table below reflects kernel version 20191030. Run show polar_supported_extensions; on your instance to get the exact list for your version.

Supported extensions for kernel version 20191030

The following extensions are supported. For Ganos spatial extensions, the Compatible extension column shows the equivalent open-source extension and version. Extensions with no open-source equivalent show N/A.

Extension	Version	Description	Compatible extension	Compatible version
`appendchildxml`	0.0.1	Appends a value to a target XML node identified by an XPath expression, adding it as a child of that node.	N/A	N/A
`btree_gin`	1.3	Adds GIN (Generalized Inverted Index) operator classes for common data types.	N/A	N/A
`btree_gist`	1.5	Adds GiST (Generalized Search Tree) operator classes for common data types.	N/A	N/A
`citext`	1.5	Provides a case-insensitive character string data type.	N/A	N/A
`cube`	1.4	Provides a data type for representing multidimensional cubes.	N/A	N/A
`dict_int`	1.0	Provides a full-text search dictionary template for indexing integers.	N/A	N/A
`earthdistance`	1.1	Provides two methods for calculating great-circle distances on Earth's surface.	N/A	N/A
`fuzzystrmatch`	1.1	Provides functions for determining string similarity, including Soundex and Levenshtein.	N/A	N/A
`hstore`	1.5	Provides a data type for storing key-value pairs in a single field.	N/A	N/A
`index_advisor`	1.0	Provides index recommendations based on query patterns.	N/A	N/A
`intagg`	1.1	Provides an integer aggregator and enumerator.	N/A	N/A
`intarray`	1.2	Provides functions and operators for manipulating integer arrays, including indexed searches.	N/A	N/A
`isn`	1.2	Provides data types for international product numbering standards (ISBN, EAN, UPC, and others).	N/A	N/A
`ltree`	1.1	Provides a data type for representing labels in a hierarchical tree structure.	N/A	N/A
`pg_buffercache`	1.3	Provides a view for inspecting the shared buffer cache in real time.	N/A	N/A
`pg_prewarm`	1.2	Provides a function for prewarming relation data into the buffer cache.	N/A	N/A
`pg_stat_statements`	1.6	Tracks execution statistics for all SQL statements run on the server.	N/A	N/A
`pg_trgm`	1.4	Provides functions and operators for determining text similarity using trigram matching.	N/A	N/A
`pg_wait_sampling`	1.1	Collects wait event sampling data for performance analysis.	N/A	N/A
`pgcrypto`	1.3	Provides cryptographic functions, including hashing and encryption.	N/A	N/A
`pgrowlocks`	1.2	Returns row lock information for a specified table.	N/A	N/A
`pgstattuple`	1.5	Provides functions for returning tuple-level statistics.	N/A	N/A
`plperl`	1.0	Provides the PL/Perl procedural language for writing server-side functions.	N/A	N/A
`plpgsql`	1.0	Provides the PL/pgSQL procedural language for writing server-side functions.	N/A	N/A
`pltcl`	1.0	Provides the PL/Tcl procedural language for writing server-side functions.	N/A	N/A
`polar_anydata`	1.0	Provides the ANYDATA data type for Oracle compatibility.	N/A	N/A
`polar_cyclechecker_noticer`	1.0	Raises an error when a `CONNECT BY` multi-clause result set contains cycle data.	N/A	N/A
`polar_gtt`	1.0	Provides functions for managing global temporary tables.	N/A	N/A
`sqlprotect`	1.0	Provides a SQL firewall to protect against unsafe query patterns.	N/A	N/A
`sslinfo`	1.2	Returns information about the SSL certificate presented by the current client connection.	N/A	N/A
`tablefunc`	1.0	Provides functions that return tables, including `crosstab`.	N/A	N/A
`unaccent`	1.1	Provides a text search dictionary that removes diacritic signs from lexemes.	N/A	N/A
`uuid-ossp`	1.1	Provides functions for generating universally unique identifiers (UUIDs).	N/A	N/A
`ganos_geometry`	2.3	Provides geography and geometry data types and spatial functions.	`postgis`	2.5.0
`ganos_raster`	2.3	Provides geographic raster data types and processing functions.	`postgis`	2.5.0
`ganos_geometry_sfcgal`	2.3	Provides 3D geometry modeling capabilities.	`postgis_sfcgal`	2.5.0
`ganos_geometry_topology`	2.3	Provides geometry topology creation and management.	`postgis_topology`	2.5.0
`ganos_tiger_geocode`	2.3	Provides TIGER-based geocoding functions.	`postgis_tiger_geocode`	2.5.0
`ganos_address_standardizer`	2.3	Provides address standardization functions for parsing and normalizing addresses.	`address_standardizer`	2.5.0
`ganos_address_standardizer_data_us`	2.3	Provides address standardization data and functions for US addresses.	`address_standardizer_data_us`	2.5.0
`ganos_networking`	2.3	Provides optimal path finding in geometric network graphs.	`pgrouting`	2.6.2
`ganos_pointcloud`	2.3	Provides data storage and computing support for point cloud data.	N/A	N/A
`ganos_trajectory`	2.3	Provides data types for storing and querying moving object trajectories.	N/A	N/A