Add an extension

Command

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

What it does

Installs the given extension in the current database (adds functions, views, types, etc.).

When to use it

When additional capabilities such as pg_stat_statements, pgcrypto or postgis are needed.

Caution

For extensions that require shared_preload_libraries, such as pg_stat_statements, first add them to postgresql.conf and restart the server. The extension files (contrib package) must be installed on the server.