Extensions add functionality to PostgreSQL — new data types, functions, index types, or whole feature sets — installed with a single command. They're a core part of Postgres's extensibility, letting you add capabilities (geospatial, advanced indexing, monitoring) without changing the core.
Installing an extension
EXTENSION IF postgis;
EXTENSION pg_stat_statements;
pg_available_extensions;
pg_extension;
