This article was contributed by Peter van Hardenberg
Peter is a co-founder of the Heroku Postgres team and hates how well he knows SQL.
Video: The Bits of Postgres You Haven't Found
Last updated 20 January 2016
Table of Contents
This presentation illustrates a dozen Postgres features that can add great value to your database: dblink, WITH syntax for common table expressions, arrays, LISTEN/NOTIFY, ranges, regular expressions, times & dates, UUIDs, window functions, hstore, full text search, TOAST, pgcrypto, pg_stat, postGIS, JSON and PL/V8.