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
|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|
|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)|