PostgreSQL Extension – Master Note

PostgreSQL available extensions in the community edition.

postgreshelp=# select name, comment from pg_available_extensions ;
        name        |                               comment
--------------------+----------------------------------------------------------------------
 plpgsql            | PL/pgSQL procedural language
 add_ten_1          | Add ten to given number
 Nvlfunc            | Oracle compatible nvl function
 cube               | data type for multidimensional cubes
 nvlfunc            | Oracle compatible nvl function
 file_fdw           | foreign-data wrapper for flat file access
 btree_gist         | support for indexing common datatypes in GiST
 fuzzystrmatch      | determine similarities and distance between strings
 add_ten            | Accept two values and add them
 pgstattuple        | show tuple-level statistics
 plperl             | PL/Perl procedural language
 pg_trgm            | text similarity measurement and index searching based 
                      on trigrams
 btree_gin          | support for indexing common datatypes in GIN
 pg_buffercache     | examine the shared buffer cache
 intarray           | functions, operators, and index support for 1-D arrays 
                      of integers
 pltclu             | PL/TclU untrusted procedural language
 sslinfo            | information about SSL certificates
 chkpass            | data type for auto-encrypted passwords
 intagg             | integer aggregator and enumerator (obsolete)
 seg                | data type for representing line segments or floating-point
                      intervals
 ltree_plpythonu    | transform between ltree and plpythonu
 repmgr             | Replication manager for PostgreSQL
 dblink             | connect to other PostgreSQL databases from within a 
                      database
 timetravel         | functions for implementing time travel
 amcheck            | functions for verifying relation integrity
 plpythonu          | PL/PythonU untrusted procedural language
 ltree              | data type for hierarchical tree-like structures
 hstore_plpythonu   | transform between hstore and plpythonu
 pageinspect        | inspect the contents of database pages at a low level
 dict_xsyn          | text search dictionary template for extended synonym 
                      processing
 autoinc            | functions for autoincrementing fields
 prog               | Demo Extension for Postgres Conference
 pgcrypto           | cryptographic functions
 uuid-ossp          | generate universally unique identifiers (UUIDs)
 citext             | data type for case-insensitive character strings
 hstore_plperlu     | transform between hstore and plperlu
 postgres_fdw       | foreign-data wrapper for remote PostgreSQL servers
 bloom              | bloom access method - signature file based index
 tablefunc          | functions that manipulate whole tables, including 
                      crosstab
 tsm_system_time    | TABLESAMPLE method which accepts time in milliseconds
 as a limit
 hstore             | data type for storing sets of (key, value) pairs
 pgrowlocks         | show row-level locking information
 insert_username    | functions for tracking who changed a table
 pg_prewarm         | prewarm relation data
 pltcl              | PL/Tcl procedural language
 refint             | functions for implementing referential integrity 
 hstore_plpython2u  | transform between hstore and plpython2u
 moddatetime        | functions for tracking last modification time
 isn                | data types for international product numbering standards
 add_cfun           | add cfun
 plpython2u         | PL/Python2U untrusted procedural language
 tcn                | Triggered change notifications
 dict_int           | text search dictionary template for integers
 lo                 | Large Object maintenance
 unaccent           | text search dictionary that removes accents
 plperlu            | PL/PerlU untrusted procedural language
 ltree_plpython2u   | transform between ltree and plpython2u
 tsm_system_rows    | TABLESAMPLE method which accepts number of rows as 
                      a limit
 demo               | Demo Extension for Postgres Conference
 pg_freespacemap    | examine the free space map (FSM)
 pg_stat_statements | track execution statistics of all SQL statements executed
 sum_fn             | sum of two numbers
 earthdistance      | calculate great-circle distances on the surface of 
                      the Earth
 adminpack          | administrative functions for PostgreSQL
 pg_visibility      | examine the visibility map (VM) and page-level 
                      visibility info
 hstore_plperl      | transform between hstore and plperl
 xml2               | XPath querying and XSLT
(67 rows)

Leave a Comment