Supported Extensions

Table 1 lists the extensions supported by Babelfish.

**Table 1** Supported extensions
Extension	Description
address_standardizer	Standardizes addresses to meet postal formatting requirements.
address_standardizer_data_us	Provides reference data required for U.S. address standardization.
amcheck	Checks the integrity of B-tree indexes to prevent data damage.
autoinc (contrib-spi)	Automatically generates sequence values in ascending order, which is usually used for auto-increment ID management.
dblink	Allows you to establish connections to other PostgreSQL databases from within a PostgreSQL session.
dict_int	Indicates an example full-text search dictionary for integers.
dict_xsyn	Indicates an example synonym full-text search dictionary. This dictionary type replaces words with groups of their synonyms in full-text search.
fuzzystrmatch	Provides fuzzy match for character strings (using the Levenshtein and Soundex algorithms).
hll	Indicates the high-performance HyperLogLog algorithm, which is used to estimate cardinality in large datasets.
insert_username (contrib-spi)	Automatically records who (username) inserted data.
intagg	Provides an integer aggregator and an enumerator.
intarray	Provides functions for efficiently manipulating arrays of integers.
ip4r	Supports efficient storage and query of IPv4 and IPv6 addresses.
isn	Provides data types and verification for international product numbering standards (such as ISBN and ISSN).
jsonb_plperl	Allows JSONB data to be processed in PL/Perl.
lo	Manages large objects, such as binary files.
moddatetime (contrib-spi)	Automatically records the last modification time of a table.
mysql_fdw	Provides a foreign data wrapper that allows PostgreSQL users to query MySQL databases.
orafce	Provides Oracle-compatible functions to facilitate Oracle database migration.
pg_buffercache	Monitors the usage of PostgreSQL shared buffers.
pg_bigm	Provides efficient 2-gram full-text search, which supports fuzzy match and quick retrieval of non-Latin languages (such as Chinese and Japanese).
pg_cron	Executes scheduled tasks in PostgreSQL (it works similar to crontab).
pg_freespacemap	Check the free space map of a table.
pg_hint_plan	Allows you to manually specify a query execution plan to optimize complex SQL queries.
pg_partman	Automatically manages partitions by time or range.
pg_prewarm	Preloads tables or indexes to a shared buffer to improve query performance.
pg_repack	Reorganizes tables online with minimal locks, which reduces table bloat.
pg_stat_statements	Records SQL execution statistics for performance analysis.
pg_trgm	Provides triplet-based fuzzy text search and similarity calculation.
pg_visibility	Checks the visibility map of a table to optimize VACUUM.
pgAudit	Provides detailed database audit logs to record SQL operations.
pgrouting	Provides geospatial routing for analyzing the shortest path and network.
pgrowlocks	Monitors row-level locking and checks for lock conflicts.
pgstattuple	Collects statistics on the physical storage of tables and indexes to help optimize space usage.
plpgsql	Indicates PostgreSQL's default procedural language (PL/pgSQL).
PostGIS	Indicates a geographic information system (GIS) extension for storing and querying spatial data.
postgis_raster	Processes raster data in PostGIS.
postgis_topology	Processes topology data in PostGIS.
postgis_sfcgal	Provides 3D geometric operations and advanced spatial analysis for PostGIS based on the SFCGAL library.
postgres_fdw	Provides a foreign data wrapper that allows PostgreSQL users to query other PostgreSQL databases.
SEG	Provides the segment data type for interval calculation.
sslinfo	Provides SSL connection information, such as client certificate details.
tablefunc	Provides table functions (such as crosstab analysis).
TCN	Provides a trigger function that notifies listeners of data change events.
tds_fdw	Allows PostgreSQL users to query SQL Server databases.
tsm_system_rows	Provides a row-based table sampling method for randomly extracting a specified number of rows of data, for example, TABLESAMPLE SYSTEM_ROWS(100).
tsm_system_time	Provides a time-based table sampling method for randomly extracting data within a specified time, for example, TABLESAMPLE SYSTEM_TIME(1000).
unaccent	Removes diacritics (such as é → e) from text to facilitate fuzzy search and standardized text processing.
uuid-ossp	Generates universally unique identifiers (UUIDs) using various algorithms, such as v1, v3, v4, and v5.
pg_sql_history	Records SQL statements executed by users for auditing and troubleshooting (log configuration is required).
rds_pg_sql_ccl	Controls the execution of concurrent SQL queries to prevent resource overload (for example, by limiting the number of concurrent connections).
rds_hwdrs_ddl	Automatically records and manages the history of DDL operations in a PostgreSQL database using event triggers, including statements for creating, modifying, and deleting objects like tables, views, and indexes.
rds_operate_privs	Provides permissions control.
pg_roaringbitmap	Compresses a bitmap calculation library efficiently for fast intersection and union operations (such as user profile analysis) on large datasets.
pg_stat_monitor	Indicates an enhanced SQL monitoring tool. It provides fine-grained query statistics (such as execution plans and error tracing).
passwordcheck	Forcibly checks password complexity (such as length, uppercase and lowercase letters, and special characters) to improve database security.
pg_qualstats	Collects predicate statistics of the WHERE clause in SQL queries to help optimize index design.
pgl_ddl_deploy	Automates DDL change deployment. It supports multi-node synchronization (for example, table structure synchronization in a primary/standby architecture).
test_decoding	Indicates a logical decoding extension, which is used to parse WALs.
auth_delay	Deliberately delays the authentication failure response (to prevent brute-force attacks). The delay time (in milliseconds) can be configured.
pageinspect	Checks the underlying storage structure (such as heap/index pages) of data pages for advanced debugging and troubleshooting.
pg_surgery	Repairs damaged table data (for example, forcibly modifies the data by bypassing constraints).
rum	Provides advanced full-text search indexes. It supports phrase search, proximity ranking, and weighted query.
xml2	Provides XML parsing and operation functions (such as XPath query and XML generation). It can process the XML data type.