Skip to content

Instantly share code, notes, and snippets.

@nulltask
Created September 29, 2014 10:56
Show Gist options
  • Select an option

  • Save nulltask/78a76269a1efd020a934 to your computer and use it in GitHub Desktop.

Select an option

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