This is my fifth blog on postgreSQL topics. This blog is collection of important extensions mostly used in postgreSQL. Extensions were implemented in PostgreSQL 9.1 to allow for easier packaging of additions to PostgreSQL. Extensions can package user-visible functions or use hooks in the PostgreSQL to modify how the database does certain processes. Create extension You can create an extension by using below syntax: CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ FROM old_version ] e.g. CREATE EXTENSION adminpack; Remove extension You can remove an extension with drop commands: DROP EXTENSION [ IF EXISTS ] extension_name [, ...] [ CASCADE | RESTRICT ] DROP EXTENSION removes extensions from the database. Dropping an extension causes its component objects to be dropped as well. You must own the extensi...