Managing PostgreSQL Extensions

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

Enable a Specific Extension

To enable the extensions you want for your application, run the following command:

$ scalingo --app my-app pgsql-console
psql (11.4)
Type "help" for help.

user=> CREATE extension hstore;
user=> CREATE extension postgis;
user=> CREATE extension "uuid-ossp";

This example uses ‘hstore’ and ‘postgis’ but you can do that for all the underneath list of extensions.

List of Available Extensions

Extension Name Version Description
btree_gin 1.3 support for indexing common datatypes in GIN
btree_gist 1.5 support for indexing common datatypes in GiST
citext 1.6 data type for case-insensitive character strings
cube 1.4 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.7 data type for storing sets of (key, value) pairs
intarray 1.3 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.4.7 lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online
pg_stat_statements 1.8 track execution statistics of all SQL statements executed
pg_trgm 1.5 text similarity measurement and index searching based on trigrams
pgcrypto 1.3 cryptographic functions
pgrowlocks 1.2 show row-level locking information
plpgsql 1.0 PL/pgSQL procedural language
postgis 3.1.3 PostGIS geometry, geography, and raster spatial types and functions
postgis_tiger_geocoder 3.1.3 PostGIS tiger geocoder and reverse geocoder
postgis_topology 3.1.3 PostGIS topology spatial types and functions
postgres_fdw 1.6 Foreign Data Wrappers affords a developer the ability to specify a foreign server and the tables in a remote database that map to federated tables in the local database.
tablefunc 1.0 functions that manipulate whole tables, including crosstab
timescaledb 2.6.0 turns PostgreSQL into a time series database
unaccent 1.1 text search dictionary that removes accents
uuid-ossp 1.1 generate universally unique identifiers (UUIDs)

Suggest edits

Managing PostgreSQL Extensions

©2023 Scalingo