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;
CREATE EXTENSION
user=> CREATE extension postgis;
CREATE EXTENSION
user=> CREATE extension "uuid-ossp";
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_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) |
Last update: 24 Feb 2022
Suggest edits