| address_standardizer | Used to structure postal addresses passed as a string |
|---|
| address_standardizer_data_us | Used to structure US and Canadian postal addresses for the address_standardizer extension |
|---|
| autoinc | Contains the autoinc() function. This function returns the next value for the sequence, which is stored in an integer type field. Unlike built-in types that control sequences, autoinc(): - blocks attempts to insert a value from the query into the field;
- allows you to change the value in the field when updating the record
|
|---|
| bloom | Adds access to database indexes based on Bloom filters, which require much less memory than hash tables but allow false positives |
|---|
| btree_gin | Contains sample classes of the GIN (Generalized Inverted Index) operator, which is used for reverse lookups |
|---|
| btree_gist | Contains classes of the GiST (Generalized Search Tree) operator. Unlike B-tree indexes, GiST supports the operators <> (not equal) and < — > (distance), although it does not provide uniqueness of returned values |
|---|
| citext | Contains the citext data type, which is used for case-insensitive string manipulation |
|---|
| cube | Contains the cube data type, which is used to represent multidimensional cubes |
|---|
| dblink | Supports connection to other PostgreSQL databases from the current session |
|---|
| dict_int | Contains an example of an additional dictionary template for full-text search, which can be used to avoid the list of unique words from growing and increase the search speed |
|---|
| dict_xsyn | Contains an example of an Extended Synonym Dictionary template for full-text search: when you search for a word, all its synonyms will be found |
|---|
| fuzzystrmatch | Contains functions that are used to determine the similarities and differences between strings |
|---|
| hstore | Contains the hstore type, which allows key/value pairs to be stored in a single table field and handled efficiently |
|---|
| intarray | Contains functions and operators for working with arrays of integers that do not contain empty (NULL) values |
|---|
| ip4r | Supports IPv4 and IPv6 address indexing to improve query performance |
|---|
| isn't | Contains data types for international product numbering standards EAN13, UPC, ISBN, ISMN and ISSN. Numbers are checked and generated by the specified list of prefixes |
|---|
| jsquery | Adds support for the JsQuery language, which is used to work with data of type jsonb. JsQuery allows to organize efficient search in nested objects and contains additional comparison operators with index support |
|---|
| lo | Contains the lo data type and the lo_manage() function, which are used to manage Binary Large Object (BLOB) according to the requirements of JDBC and ODBC driver specifications (the standard PostgreSQL behavior does not comply with them) |
|---|
| ltree | Contains the ltree data type to represent data labels stored in a tree-like hierarchical structure |
|---|
| moddatetime | Contains the moddatetime() function, which allows you to track the time of the last modification of a table row |
|---|
| pg_partman | Adds advanced table partitioning capabilities, including time-based or sequence-based table partitioning |
|---|
| pg_repack | Allows to rebuild tables and indexes without locking to reduce their size and fragmentation. The dbaas_admin role is required to use the extension — this role is automatically assigned to the database owner, it cannot be assigned to other users |
|---|
| pg_stat_statements | Adds the ability to track scheduling and collect execution statistics of all SQL queries running in the cluster. To use the extension, the dbaas_admin role is required — this role is automatically assigned to the database owner, it cannot be assigned to other users |
|---|
| pgtrgm | Contains tools to quickly find similar strings based on trigram matching |
|---|
| pgcrypto | Provides a set of cryptographic functions to protect data. Learn more about data encryption with the pgcrypto extension and examples of use in the Data Encryption tutorial. |
|---|
| pgrowlocks | Contains the pgrowlocks() function, which returns information about row locks in the specified table |
|---|
| pgstattuple | Provides detailed statistics on disk space usage and allows you to analyze index fragmentation, the number of "dead" tuples and free space. The extension is useful for performance diagnostics, index optimization and scheduling VACUUM and AUTOVACUUM operations |
|---|
| pgTAP | Provides a set of tools for testing database schema and SQL functions |
|---|
| plv8 | Allows you to use JavaScript to write stored procedures and triggers |
|---|
| postgis | Allows storing and processing geographic information system (GIS) objects in PostgreSQL databases. To use the extension, the dbaas_admin role is required — this role is automatically assigned to the database owner, it cannot be assigned to other users |
|---|
| postgis_raster | Allows you to work with raster images and analyze geographic information system (GIS) objects in databases |
|---|
| postgis_fdw | Adds support for Foreign Data Wrapper to access external PostgreSQL servers. The dbaas_admin role is required to use the extension — this role is automatically given to the database owner, it cannot be assigned to other users |
|---|
| prefix | Adds support for prefixes and masks to optimize queries |
|---|
| rum | Adds an access method for working with RUM indexes |
|---|
| seg | Contains the seg data type for representing line segments or floating point intervals |
|---|
| tablefunc | Contains a set of functions that return tables (sets of rows) |
|---|
| unaccent | Contains a dictionary for searching text without diacritical marks |
|---|
| uuid-ossp | Contains functions for generating UUIDs using standard algorithms |
|---|
| vector | Allows you to work with vector data — store, index and execute queries |
|---|
| xml2 | Adds support for XPath queries and XSLT language |
|---|