Managing PostgreSQL extensions

You need to have our command-line tool installed.
Instructions are detailed in Command-Line Tool Documentation and installer page.

PostgreSQL is a database engine which is extensible thanks to a large set of extensions. A lot of them a 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 -a <appname> pgsql-console
psql (9.4.5)
Type "help" for help.

user=> CREATE extension hstore;
CREATE EXTENSION
user=> CREATE extension postgis;
CREATE EXTENSION

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_gist 1.0 support for indexing common datatypes in GiST
citext 1.0 data type for case-insensitive character strings
cube 1.0 data type for multidimensional cubes
dblink 1.1 connect to other PostgreSQL databases from within a database
dict_int 1.0 text search dictionary template for integers
earthdistance 1.0 calculate great-circle distances on the surface of the Earth
fuzzystrmatch 1.0 determine similarities and distance between strings
hstore 1.3 data type for storing sets of (key, value) pairs
intarray 1.0 functions, operators, and index support for 1-D arrays of integers
isn 1.0 data types for international product numbering standards
ltree 1.0 data type for hierarchical tree-like structures
pg_stat_statements 1.2 track execution statistics of all SQL statements executed
pg_trgm 1.1 text similarity measurement and index searching based on trigrams
pgcrypto 1.1 cryptographic functions
pgrowlocks 1.1 show row-level locking information
plpgsql 1.0 PL/pgSQL procedural language
postgis 2.1.8 PostGIS geometry, geography, and raster spatial types and functions
postgis_tiger_geocoder 2.1.8 PostGIS tiger geocoder and reverse geocoder
postgis_topology 2.1.8 PostGIS topology spatial types and functions
tablefunc 1.0 functions that manipulate whole tables, including crosstab
unaccent 1.0 text search dictionary that removes accents
uuid-ossp 1.0 generate universally unique identifiers (UUIDs)
schedule 05 Nov 2015