PostgreSQL extensions on Mendix cloud

PostgreSQL extensions are add-on modules that enhance the functionality of the database solution.

This page shows which extensions can be loaded on the Mendix cloud (i.e. modules that are trusted, that is, it can be installed by non-superusers who have CREATE privilege on the current database).

NameVersionDescriptionRequires
bool_plperl1.0transform between bool and plperlplperl
btree_gin1.0, 1.1, 1.2, 1.3support for indexing common datatypes in GIN
btree_gist1.2, 1.3, 1.4, 1.5, 1.6support for indexing common datatypes in GiST
citext1.4, 1.5, 1.6data type for case-insensitive character strings
cube1.2, 1.3, 1.4, 1.5data type for multidimensional cubes
dict_int1.0text search dictionary template for integers
fuzzystrmatch1.1determine similarities and distance between strings
hstore1.4, 1.5, 1.6, 1.7, 1.8data type for storing sets of (key, value) pairs
intarray1.2, 1.3, 1.4, 1.5functions, operators, and index support for 1-D arrays of integers
isn1.1, 1.2data types for international product numbering standards
jsonb_plperl1.0transform between jsonb and plperlplperl
lo1.1Large Object maintenance
ltree1.1, 1.2data type for hierarchical tree-like structures
pg_trgm1.3, 1.4, 1.5, 1.6text similarity measurement and index searching based on trigrams
pgcrypto1.3cryptographic functions
plperl1.0PL/Perl procedural language
plpgsql1.0PL/pgSQL procedural language
pltcl1.0PL/Tcl procedural language
seg1.1, 1.2, 1.3, 1.4data type for representing line segments or floating-point intervals
tablefunc1.0functions that manipulate whole tables, including crosstab
tcn1.0Triggered change notifications
tsm_system_rows1.0TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time1.0TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent1.1text search dictionary that removes accents
uuid-ossp1.1generate universally unique identifiers (UUIDs)

Checked against Mendix Cloud US running PostgreSQL 14.9