PostgreSQL extensions

You can use PostgreSQL extensions with Timescale Cloud. If you run pg_available_extensions at the command prompt, the returned list of extensions is inaccurate. To see the allowed extensions, use this command instead:

2. SELECT pae.* FROM current_setting('extwlist.extensions') AS cs(e) CROSS JOIN regexp_split_to_table(e, ',') AS ext(allowed) JOIN pg_available_extensions AS pae ON (allowed=name) ORDER BY 1;

These are the currently supported extensions:

Extension Description
bloom Bloom access method - signature file based index
btree_gin Support for indexing common datatypes in GIN
btree_gist Support for indexing common datatypes in GiST
citext Data type for case-insensitive character strings
cube Data type for multidimensional cubes
dict_int Text search dictionary template for integers
dict_xsyn Text search dictionary template for extended synonym processing
fuzzystrmatch Determine similarities and distance between strings
hstore Data type for storing sets of (key, value) pairs
intarray Functions, operators, and index support for 1-D arrays of integers
isn Data types for international product numbering standards
lo Large Object maintenance
ltree Data type for hierarchical tree-like structures
pg_stat_statements Track execution statistics of all SQL statements executed
pg_trgm Text similarity measurement and index searching based on trigrams
pgcrypto Cryptographic functions
pgrouting pgRouting Extension
postgis PostGIS geometry and geography spatial types and functions
postgis_raster PostGIS raster types and functions
postgis_sfcgal PostGIS SFCGAL functions
postgis_tiger_geocoder PostGIS tiger geocoder and reverse geocoder
postgis_topology PostGIS topology spatial types and functions
promscale Promscale support functions
seg data type for representing line segments or floating-point intervals
tablefunc Functions that manipulate whole tables, including crosstab
tcn Triggered change notifications
timescaledb_toolkit TimescaleDB Toolkit
timescaledb Enables scalable inserts and complex queries for time-series data
tsm_system_rows TABLESAMPLE method which accepts number of rows as a limit
tsm_system_time TABLESAMPLE method which accepts time in milliseconds as a limit
unaccent Text search dictionary that removes accents
uuid-ossp Generate universally unique identifiers (UUIDs)