gistfile1.txt

book=# SELECT * FROM pg_available_extensions;
        name        | default_version | installed_version |                               comment                                
--------------------+-----------------+-------------------+----------------------------------------------------------------------
 adminpack          | 1.0             |                   | administrative functions for PostgreSQL
 autoinc            | 1.0             |                   | functions for autoincrementing fields
 btree_gin          | 1.0             |                   | support for indexing common datatypes in GIN
 btree_gist         | 1.0             |                   | support for indexing common datatypes in GiST
 chkpass            | 1.0             |                   | data type for auto-encrypted passwords
 citext             | 1.0             |                   | data type for case-insensitive character strings
 cube               | 1.0             | 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
 dict_xsyn          | 1.0             |                   | text search dictionary template for extended synonym processing
 earthdistance      | 1.0             |                   | calculate great-circle distances on the surface of the Earth
 file_fdw           | 1.0             |                   | foreign-data wrapper for flat file access
 fuzzystrmatch      | 1.0             |                   | determine similarities and distance between strings
 hstore             | 1.3             |                   | data type for storing sets of (key, value) pairs
 insert_username    | 1.0             |                   | functions for tracking who changed a table
 intagg             | 1.0             |                   | integer aggregator and enumerator (obsolete)
 intarray           | 1.0             |                   | functions, operators, and index support for 1-D arrays of integers
 isn                | 1.0             |                   | data types for international product numbering standards
 lo                 | 1.0             |                   | Large Object maintenance
 ltree              | 1.0             |                   | data type for hierarchical tree-like structures
 moddatetime        | 1.0             |                   | functions for tracking last modification time
 pageinspect        | 1.2             |                   | inspect the contents of database pages at a low level
 pg_buffercache     | 1.0             |                   | examine the shared buffer cache
 pg_freespacemap    | 1.0             |                   | examine the free space map (FSM)
 pg_prewarm         | 1.0             |                   | prewarm relation data
 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
 pgstattuple        | 1.2             |                   | show tuple-level statistics
 plperl             | 1.0             |                   | PL/Perl procedural language
 plperlu            | 1.0             |                   | PL/PerlU untrusted procedural language
 plpgsql            | 1.0             | 1.0               | PL/pgSQL procedural language
 pltcl              | 1.0             |                   | PL/Tcl procedural language
 pltclu             | 1.0             |                   | PL/TclU untrusted procedural language
 postgres_fdw       | 1.0             |                   | foreign-data wrapper for remote PostgreSQL servers
 refint             | 1.0             |                   | functions for implementing referential integrity (obsolete)
 seg                | 1.0             |                   | data type for representing line segments or floating-point intervals
 sslinfo            | 1.0             |                   | information about SSL certificates
 tablefunc          | 1.0             |                   | functions that manipulate whole tables, including crosstab
 tcn                | 1.0             |                   | Triggered change notifications
 test_parser        | 1.0             |                   | example of a custom parser for full-text search
 test_shm_mq        | 1.0             |                   | Test code for shared memory message queues
 timetravel         | 1.0             |                   | functions for implementing time travel
 tsearch2           | 1.0             |                   | compatibility package for pre-8.3 text search functions
 unaccent           | 1.0             |                   | text search dictionary that removes accents
 uuid-ossp          | 1.0             |                   | generate universally unique identifiers (UUIDs)
 worker_spi         | 1.0             |                   | Sample background worker
 xml2               | 1.0             |                   | XPath querying and XSLT
(49 rows)

book=#