tenant capabilities

Allowed extensions

60 total

Install from SQL

These extensions are available to every tenant database. An extension becomes active only after the database owner installs it with standard PostgreSQL SQL. No control-plane action is required.

CREATE EXTENSION vector;

Available extensions

`address_standardizer`

Parses an address into parts for normalization and geocoding.

`address_standardizer_data_us`

Adds United States address rules and lookup data for address_standardizer.

`amcheck`

Checks B-tree indexes and other relations for structural corruption.

`autoinc`

Adds trigger functions that increment numeric fields.

`bloom`

Adds Bloom indexes for compact multi-column equality searches.

`bool_plperl`

Converts boolean values between PostgreSQL and PL/Perl.

`btree_gin`

Adds GIN operator classes with B-tree behavior for common data types.

`btree_gist`

Adds GiST operator classes with B-tree behavior for common data types.

`citext`

Adds a case-insensitive text data type.

`cube`

Adds multidimensional cube data and distance operations.

`dict_int`

Adds a full-text search dictionary for integers.

`dict_xsyn`

Adds an extended synonym dictionary for full-text search.

`earthdistance`

Calculates great-circle distances on the surface of Earth.

`fuzzystrmatch`

Adds phonetic matching and edit-distance functions for strings.

`h3`

Adds Uber H3 hierarchical geospatial cells and operations.

`h3_postgis`

Connects H3 cell operations with PostGIS geometry and geography data.

`hll`

Adds HyperLogLog values for approximate distinct counts.

`hstore`

Stores sets of key-value pairs in one PostgreSQL value.

`hstore_plperl`

Converts hstore values between PostgreSQL and PL/Perl.

`hypopg`

Tests hypothetical indexes in query plans without building the indexes.

`insert_username`

Adds trigger functions that record who changed a table.

`intagg`

Adds legacy integer aggregation and enumeration functions.

`intarray`

Adds functions, operators, and indexes for one-dimensional integer arrays.

`ip4r`

Adds indexed IPv4 and IPv6 address and range data types.

`isn`

Adds data types for ISBN, ISSN, UPC, and other product numbers.

`jsonb_plperl`

Converts JSONB values between PostgreSQL and PL/Perl.

`lo`

Maintains PostgreSQL large objects that table rows reference.

`ltree`

Stores and indexes hierarchical tree paths.

`moddatetime`

Adds a trigger that records the last modification time of a row.

`pg_bigm`

Adds bigram similarity and indexed LIKE searches.

`pg_freespacemap`

Inspects the free-space map for tables and indexes.

`pg_hint_plan`

Lets SQL comments influence PostgreSQL planner choices.

`pg_partman`

Manages time-based and ID-based table partitions.

`pg_prewarm`

Loads relation data into PostgreSQL or operating-system caches.

`pg_similarity`

Adds multiple string similarity algorithms and operators.

`pg_trgm`

Adds trigram similarity and indexed LIKE or ILIKE searches.

`pg_visibility`

Inspects visibility maps and page-level visibility information.

`pgcrypto`

Adds hashing, encryption, and cryptographic random-data functions.

`pgrouting`

Adds graph routing algorithms for PostGIS data.

`pgrowlocks`

Shows row-level lock information.

`pgstattuple`

Shows physical tuple, free-space, and table-bloat statistics.

`pgtap`

Adds SQL functions for database unit tests.

`plperl`

Adds the trusted PL/Perl procedural language.

`pltcl`

Adds the trusted PL/Tcl procedural language.

`postgis`

Adds geometry, geography, spatial indexes, and geospatial analysis.

`postgis_raster`

Adds raster data types and analysis to PostGIS.

`postgis_topology`

Adds topology data types and operations to PostGIS.

`prefix`

Stores and indexes prefix ranges for fast prefix matching.

`rdkit`

Adds chemical structures, descriptors, and similarity searches.

`refint`

Adds legacy trigger functions for referential integrity. Prefer native foreign keys.

`roaringbitmap`

Adds compressed Roaring Bitmap values and operations.

`seg`

Stores line segments and floating-point intervals with GiST indexes.

`sslinfo`

Shows details about the current TLS connection and client certificate.

`tablefunc`

Adds table transformations, including crosstab and pivot queries.

`tcn`

Sends trigger-based change notifications through PostgreSQL NOTIFY.

`tsm_system_rows`

Adds TABLESAMPLE selection by an approximate number of rows.

`tsm_system_time`

Adds TABLESAMPLE selection by a time limit in milliseconds.

`unaccent`

Removes accents for text normalization and full-text search.

`uuid-ossp`

Generates standard universally unique identifiers.

`vector`

Stores embeddings and adds exact, IVFFlat, and HNSW vector search.