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