Skip to content

Instantly share code, notes, and snippets.

@Mikulas
Created November 26, 2015 14:31
Show Gist options
  • Save Mikulas/956d91f3677eedb19a22 to your computer and use it in GitHub Desktop.
Save Mikulas/956d91f3677eedb19a22 to your computer and use it in GitHub Desktop.
aws rds pg exts
pg_available_extensions
(pg_trgm,1.1,"text similarity measurement and index searching based on trigrams")
(pgcrypto,1.1,"cryptographic functions")
(chkpass,1.0,"data type for auto-encrypted passwords")
(test_shm_mq,1.0,"Test code for shared memory message queues")
(earthdistance,1.0,"calculate great-circle distances on the surface of the Earth")
(plpgsql,1.0,"PL/pgSQL procedural language")
(intarray,1.0,"functions, operators, and index support for 1-D arrays of integers")
(postgis_tiger_geocoder,2.1.5,"PostGIS tiger geocoder and reverse geocoder")
(plls,1.4.3,"PL/LiveScript (v8) trusted procedural language")
(pgrowlocks,1.1,"show row-level locking information")
(cube,1.0,"data type for multidimensional cubes")
(btree_gin,1.0,"support for indexing common datatypes in GIN")
(tablefunc,1.0,"functions that manipulate whole tables, including crosstab")
(sslinfo,1.0,"information about SSL certificates")
(plperl,1.0,"PL/Perl procedural language")
(plv8,1.4.3,"PL/JavaScript (v8) trusted procedural language")
(intagg,1.0,"integer aggregator and enumerator (obsolete)")
(test_parser,1.0,"example of a custom parser for full-text search")
(pg_prewarm,1.0,"prewarm relation data")
(postgres_fdw,1.0,"foreign-data wrapper for remote PostgreSQL servers")
(dict_xsyn,1.0,"text search dictionary template for extended synonym processing")
(pg_buffercache,1.0,"examine the shared buffer cache")
(dict_int,1.0,"text search dictionary template for integers")
(pg_stat_statements,1.2,"track execution statistics of all SQL statements executed")
(fuzzystrmatch,1.0,"determine similarities and distance between strings")
(dblink,1.1,"connect to other PostgreSQL databases from within a database")
(hstore,1.3,"data type for storing sets of (key, value) pairs")
(pgstattuple,1.2,"show tuple-level statistics")
(tsearch2,1.0,"compatibility package for pre-8.3 text search functions")
(citext,1.0,"data type for case-insensitive character strings")
(plcoffee,1.4.3,"PL/CoffeeScript (v8) trusted procedural language")
(ltree,1.0,"data type for hierarchical tree-like structures")
(worker_spi,1.0,"Sample background worker")
(xml2,1.0,"XPath querying and XSLT")
(isn,1.0,"data types for international product numbering standards")
(postgis,2.1.5,"PostGIS geometry, geography, and raster spatial types and functions")
(unaccent,1.0,"text search dictionary that removes accents")
(pg_freespacemap,1.0,"examine the free space map (FSM)")
(postgis_topology,2.1.5,"PostGIS topology spatial types and functions")
(pltcl,1.0,"PL/Tcl procedural language")
(uuid-ossp,1.0,"generate universally unique identifiers (UUIDs)")
(btree_gist,1.0,"support for indexing common datatypes in GiST")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment