<p>Currently, RDS PostgreSQL supports the following plug-in:</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top; width:222px"> <p><strong>Plug-in name</strong></p> </td> <td style="background-color:#ededed; vertical-align:top; width:566px"> <p><strong>Description&nbsp;</strong></p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>PostGIS&nbsp;</p> </td> <td style="vertical-align:top; width:566px"> <p>Geographic information data&nbsp;</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>fuzzystrmatch&nbsp;</p> </td> <td style="vertical-align:top; width:566px"> <p>Fuzzy match of character string</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pgcrypto</p> </td> <td style="vertical-align:top; width:566px"> <p>Encryption function</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>intarray</p> </td> <td style="vertical-align:top; width:566px"> <p>Function, operator, and index that are relevant to integer array</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>cstore_fdw</p> </td> <td style="vertical-align:top; width:566px"> <p>Use RC_file format for column-based storage of data</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pg_pathman</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides function with flexible partition</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>zhparser</p> </td> <td style="vertical-align:top; width:566px"> <p>Chinese full-text search</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>address_standardizer</p> </td> <td style="vertical-align:top; width:566px"> <p>It supports formating data of geographic position</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>address_standardizer_data_us</p> </td> <td style="vertical-align:top; width:566px"> <p>It supports formating data of geographic position</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>postgis_tiger_geocoder</p> </td> <td style="vertical-align:top; width:566px"> <p>Geocoding</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>postgis_topology</p> </td> <td style="vertical-align:top; width:566px"> <p>It supports topological operations with functions</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>autoinc</p> </td> <td style="vertical-align:top; width:566px"> <p>Function used in increment domain</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>bloom</p> </td> <td style="vertical-align:top; width:566px"> <p>It supports index access method of bloom filter</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>btree_gin</p> </td> <td style="vertical-align:top; width:566px"> <p>It supports gin index</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>btree_gist</p> </td> <td style="vertical-align:top; width:566px"> <p>It supports gist index</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>citext</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides case-insensitive text field</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>cube</p> </td> <td style="vertical-align:top; width:566px"> <p>It provide cube of multiple data types</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>dblink</p> </td> <td style="vertical-align:top; width:566px"> <p>It supports connecting to other PostgreSQL database in a database session</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>earthdistance</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides two methods to calculate ground circle distance on the earth surface</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>fuzzystrmatch</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides multiple functions to determine the similarity and distance between character strings</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>hstore</p> </td> <td style="vertical-align:top; width:566px"> <p>hstore data type is used to store key-value pairs in a single PostgreSQL value</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>insert_username</p> </td> <td style="vertical-align:top; width:566px"> <p>It tracks the user who modifies functions of a table</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>intarray</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides some useful functions and operators to operate integer arrays that have no null value</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>isn</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides data types for the international numbering standard of the following products:</p> <p>EAN13, UPC, ISBN (book), ISMN (music), and ISSN (periodical)</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>lo</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides support for managing large-scale objects (also called LO or BLOB) It includes a data type lo and a trigger lo_manage</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>ltree</p> </td> <td style="vertical-align:top; width:566px"> <p>The data type ltree represents the tags of data stored in one hierarchy of the tree structure. It also has expansion function of searching in the tag tree</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>moddatetime</p> </td> <td style="vertical-align:top; width:566px"> <p>It tracks functions for the last modification time</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pg_buffercache</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides a method to check shared buffer in real time Only super accounts and role members of pg_read_all_stats can use this plug-in</p> <p>You need to submit a Ticket if you want to use this plug-in</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pg_freespacemap</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides a method to check free space mapping (FSM). It will withdraw public access from functions to avoid potential security issues. Only super accounts and role members of pg_read_all_stats can use this plug-in.</p> <p>You need to submit a Ticket if you want to use this plug-in.</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pg_prewarm</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides a convenient method to load relational data into the operating system buffer or PostgreSQL buffer.</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pgrowlocks</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides a function to present row lock information of a designated table.</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pg_stat_statements</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides a method to track the execution statistics of all SQL statements executed by a server.</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pgstattuple</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides multiple functions to obtain statistics of layers of tuples</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pg_trgm</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides functions and operators that determine the similarity of letters, digits, and texts that are based on trigram matching</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>pg_visibility</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides a method to check visibility map (VM) and page-level visibility information. It also provides a function to check the integrity of VM and re-establish VM in a mandatory way.</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>postgres_fdw</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides the external data wrapper postgres_fdw, and can be used to access data stored in an external PostgreSQL server.</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>refint</p> </td> <td style="vertical-align:top; width:566px"> <p>It is used in functions that realize referential integrity.</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>seg</p> </td> <td style="vertical-align:top; width:566px"> <p>It is a data type to present line segment or floating-point interval. seg can represent uncertainty in the interval endpoints, making it especially useful for representing laboratory measurements</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>tablefunc</p> </td> <td style="vertical-align:top; width:566px"> <p>It includes function of multiple return (namely multiple rows)</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>tcn</p> </td> <td style="vertical-align:top; width:566px"> <p>It provides a trigger function and notify listener of changes of any table it attaches to. It must be used as a row-level AFTER trigger</p> </td> </tr> <tr> <td style="vertical-align:top; width:222px"> <p>timetravel</p> </td> <td style="vertical-align:top; width:566px"> <p>It is a function that realizes time travel</p> </td> </tr> </tbody> </table>