File:Useful yet frequently omitted extensions.pdf

Summary

One of the PostgreSQL advantages is extreme flexibility and extensibility. Sadly only a very small fraction of the developers has a clear overview of what extensions are available, i.e. plugins that are easy to install and provide non-traditional custom data types, non-traditional data types, various libraries, administrative tools, and so on. Let's look at some interesting useful extensions that you might find useful - some delivered with PostgreSQL (hstore, ltree, pgcrypto, pg_stat_statements ...), some available on sites like PGXN (semversion, pg_reorg, pg_tap ...) or GitHub.

Licensing

Released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.