Database extension
A database extension is an installable software package that adds data types, functions, operators, indexes, or other capabilities to a database system.
Just Use Postgres!
A Postgres extension is an installable package that adds data types, functions, operators, indexes, or other capabilities to a PostgreSQL database system.
- How it is used
- Uses extensions to expand Postgres beyond core relational workloads and tailor database behavior for applications.
- How deep it goes
- Explains catalogs, hooks, dynamic loading, installation, and inspection, but only surveys extension categories and omits detailed deployment guidance.
- Examples
- Demonstrates pg_available_extensions, expanded psql output, installed-version filtering, and bundled extensions including plpgsql.
- What you can do after
- Operate/configure extensions by inspecting server availability and distinguishing available versions from extensions enabled in a database.
DuckDB in Action
A database extension is an installable software component that adds capabilities to a database system.
- How it is used
- Adds optional capabilities for remote files, cloud databases, and query execution beyond DuckDB’s core engine.
- How deep it goes
- Explains discovery, installation, loading, idempotence, autoloading, and execution placement, but does not detail extension development.
- Examples
- Demonstrates duckdb_extensions(), httpfs installation, remote CSV queries, MotherDuck management, and MD_RUN-controlled reads.
- What you can do after
- Operate/configure DuckDB extensions by inspecting availability, installing and loading packages, and selecting local or remote execution.
What to know first
- JSONJSON is a language-independent text-based data-interchange format that represents structured values using objects, arrays, strings, numbers, booleans, and null.
- SQLSQL is a standardized declarative language for defining, querying, and manipulating data in relational database systems.
Related concepts
- auto_explainincludes · auto_explain is a PostgreSQL extension that automatically logs execution plans for queries meeting configured conditions.
- pg_statvizincludes · pg_statviz is a PostgreSQL extension for capturing, storing, analyzing, and visualizing database statistics over time.
- pgvectorincludes · pgvector is a PostgreSQL extension that adds vector data types, similarity operations, and indexes for storing and searching vector data.
- TimescaleDBincludes · TimescaleDB is a PostgreSQL extension optimized for storing and querying time-series data.
- callbackuses · A callback is a function or other callable supplied or registered with a component for invocation at a specified event, condition, or point in execution.
Questions about database extension
What is database extension?
A database extension is an installable software package that adds data types, functions, operators, indexes, or other capabilities to a database system.
Which Manning books explain database extension?
Just Use Postgres! and DuckDB in Action.
What should I know before learning database extension?
Manning books that teach database extension usually introduce JSON and SQL first.
What kinds of database extension are there?
Kinds of database extension include auto_explain, pg_statviz, plpgsql_check, pgvector and TimescaleDB.
What is database extension also called?
Database extension is also called PostgreSQL extension.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.

