Managing Extensions of Your Scalingo for PostgreSQL® Addon

PostgreSQL® is a database engine which is extensible thanks to a large set of extensions. A lot of them are installed alongside your PostgreSQL® instance, but you need to enable those manually according to your needs.

Please note that we have dedicated pages for some of the most popular extensions:

Available Extensions

Name	Version	Description
`btree_gin`	`1.3`	support for indexing common datatypes in GIN
`btree_gist`	`1.7`	support for indexing common datatypes in GiST
`citext`	`1.6`	data type for case-insensitive character strings
`cube`	`1.5`	data type for multidimensional cubes
`dblink`	`1.2`	connect to other PostgreSQL databases from within a database
`dict_int`	`1.0`	text search dictionary template for integers
`earthdistance`	`1.1`	calculate great-circle distances on the surface of the Earth
`fuzzystrmatch`	`1.1`	determine similarities and distance between strings
`hstore`	`1.8`	data type for storing sets of (key, value) pairs
`intarray`	`1.5`	functions, operators, and index support for 1-D arrays of integers
`isn`	`1.2`	data types for international product numbering standards
`ltree`	`1.2`	data type for hierarchical tree-like structures
`pg_repack`	`1.5.1`	Reorganize tables in PostgreSQL databases with minimal locks
`pg_stat_statements`	`1.10`	track planning and execution statistics of all SQL statements executed
`pg_trgm`	`1.6`	text similarity measurement and index searching based on trigrams
`pgcrypto`	`1.3`	cryptographic functions
`pgrowlocks`	`1.2`	show row-level locking information
`postgis`	`3.5.0`	PostGIS geometry and geography spatial types and functions
`postgis_raster`	`3.5.0`	PostGIS raster types and functions
`postgis_sfcgal`	`3.5.0`	PostGIS SFCGAL functions
`postgis_tiger_geocoder`	`3.5.0`	PostGIS tiger geocoder and reverse geocoder
`postgis_topology`	`3.5.0`	PostGIS topology spatial types and functions
`postgres_fdw`	`1.1`	foreign-data wrapper for remote PostgreSQL servers
`tablefunc`	`1.0`	functions that manipulate whole tables, including crosstab
`timescaledb`	`2.17.2`	Enables scalable inserts and complex queries for time-series data
`unaccent`	`1.1`	text search dictionary that removes accents
`uuid-ossp`	`1.1`	generate universally unique identifiers (UUIDs)
`vector`	`0.8.0`	vector data type and ivfflat and hnsw access methods

Enabling an Extension

Using the Command Line

Access your database using the Interactive Remote Console
From the PostgreSQL® console, run the following command:
```
CREATE EXTENSION IF NOT EXISTS <extension_name>;
```
The output should look like this:
```
CREATE EXTENSION
my_app_4553=>
```

Disabling an Extension

Using the Command Line

Access your database using the Interactive Remote Console
From the PostgreSQL® console, run the following command:
```
DROP EXTENSION IF EXISTS <extension_name>;
```
The output should look like this:
```
DROP EXTENSION
my_app_4553=>
```

Last update: 05 Nov 2024 Suggest edits