gistfile1.txt

  name          | version | installed | superuser | relocatable |   schema   |        requires         |                               comment                               
------------------------+---------+-----------+-----------+-------------+------------+-------------------------+---------------------------------------------------------------------
 btree_gin              | 1.0     | f         | t         | t           |            |                         | support for indexing common datatypes in GIN
 dblink                 | 1.1     | f         | t         | t           |            |                         | connect to other PostgreSQL databases from within a database
 unaccent               | 1.0     | f         | t         | t           |            |                         | text search dictionary that removes accents
 intarray               | 1.0     | f         | t         | t           |            |                         | functions, operators, and index support for 1-D arrays of integers
 plpgsql                | 1.0     | t         | f         | f           | pg_catalog |                         | PL/pgSQL procedural language
 pgstattuple            | 1.1     | f         | t         | t           |            |                         | show tuple-level statistics
 pg_trgm                | 1.1     | f         | t         | t           |            |                         | text similarity measurement and index searching based on trigrams
 ltree                  | 1.0     | f         | t         | t           |            |                         | data type for hierarchical tree-like structures
 pltcl                  | 1.0     | f         | f         | f           | pg_catalog |                         | PL/Tcl procedural language
 fuzzystrmatch          | 1.0     | f         | t         | t           |            |                         | determine similarities and distance between strings
 pg_buffercache         | 1.0     | f         | t         | t           |            |                         | examine the shared buffer cache
 intagg                 | 1.0     | f         | t         | t           |            |                         | integer aggregator and enumerator (obsolete)
 tablefunc              | 1.0     | f         | t         | t           |            |                         | functions that manipulate whole tables, including crosstab
 uuid-ossp              | 1.0     | f         | t         | t           |            |                         | generate universally unique identifiers (UUIDs)
 cube                   | 1.0     | f         | t         | t           |            |                         | data type for multidimensional cubes
 postgis                | 2.1.0   | f         | t         | t           |            |                         | PostGIS geometry, geography, and raster spatial types and functions
 pg_freespacemap        | 1.0     | f         | t         | t           |            |                         | examine the free space map (FSM)
 btree_gist             | 1.0     | f         | t         | t           |            |                         | support for indexing common datatypes in GiST
 earthdistance          | 1.0     | f         | t         | t           |            | {cube}                  | calculate great-circle distances on the surface of the Earth
 tsearch2               | 1.0     | f         | t         | f           |            |                         | compatibility package for pre-8.3 text search functions
 pg_stat_statements     | 1.1     | f         | t         | t           |            |                         | track execution statistics of all SQL statements executed
 postgis_tiger_geocoder | 2.1.0   | f         | t         | f           | tiger      | {postgis,fuzzystrmatch} | PostGIS tiger geocoder and reverse geocoder
 hstore                 | 1.2     | f         | t         | t           |            |                         | data type for storing sets of (key, value) pairs
 postgis_topology       | 2.1.0   | f         | t         | f           | topology   | {postgis}               | PostGIS topology spatial types and functions
 dict_xsyn              | 1.0     | f         | t         | t           |            |                         | text search dictionary template for extended synonym processing
 sslinfo                | 1.0     | f         | t         | t           |            |                         | information about SSL certificates
 isn                    | 1.0     | f         | t         | t           |            |                         | data types for international product numbering standards
 dict_int               | 1.0     | f         | t         | t           |            |                         | text search dictionary template for integers
 citext                 | 1.0     | f         | t         | t           |            |                         | data type for case-insensitive character strings
 pgrowlocks             | 1.1     | f         | t         | t           |            |                         | show row-level locking information
 pgcrypto               | 1.0     | t         | t         | t           |            |                         | cryptographic functions
 plperl                 | 1.0     | f         | f         | f           | pg_catalog |                         | PL/Perl procedural language
 postgres_fdw           | 1.0     | f         | t         | t           |            |                         | foreign-data wrapper for remote PostgreSQL servers
 chkpass                | 1.0     | f         | t         | t           |            |                         | data type for auto-encrypted passwords
(34 rows)