Skip to content

Instantly share code, notes, and snippets.

@denishpatel
Created November 15, 2013 02:22
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save denishpatel/7478115 to your computer and use it in GitHub Desktop.
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment