Skip to content

Instantly share code, notes, and snippets.

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