PostgreSQL Extensions: A Deep Dive
summary
Shows exact, runnable specifics: control and .sql files, a C module with PG_MODULE_MAGIC, and makefile targets that install into PostgreSQL’s extension directory; commands shown include create extension demo and pg_available_extensions and the exact upgrade-file naming like demo--1.0-to-1.1.sql. Demonstrations loadable modules (auto_explain), SPI calls that execute SELECT version, foreign data wrapper handler/validator hooks, and the need to add libraries to shared_preload_libraries for parameters that require preload.
AI-written summary · about
chapters (8)
- 0:00Start
- 1:54What are PostgreSQL Extensions? Extend beyond Core PostgreSQL functionality Customize existing functionality Loadable set of functions Adding new features to PostgreSQL core
- 5:04Using PostgreSQL Extension testdb=# CREATE EXTENSION Pg_stat_statements
- 7:49Upgrade and removing PostgreSQL Extensions Upgrade extension • ALTER EXTENSION name UPDATE; • ALTER EXTENSION nane UPDATE TO '2.5.2'
- 12:31PostgreSQL Plugins Logical Decoding Output Plugins • Shared library loaded dynamically Examples: • test_decoder • decoder_raw
- 13:28New Extensions in Amazon RDS for PostgreSQL .85+ extensions and plugins supported in Amazon RDS • Recent additions include
- 15:13Requirements of an Extension Minimum extension requirements • Requires a control file
- 22:17Upgrading PostgreSQL Extensions
related talks
28mBeyond Postgres: Insights about the PostgreSQL Extensibility
48mTricky SQL: Special Features of PostgreSQL's SQL Dialect
52mThe trouble with extensions
26mState of the Postgres Extension Ecosystem
52mAnarchy in the Database: A Survey and Evaluation of Database Management System Extensibility
29mSELECT 'amazing_features' FROM "postgresql"
05mpgextensions org Your Guide to PostgreSQL Extensions Comparision on the Cloud
24mDeveloping DB Extensions in Python: Examples for SQLite, DuckDB & PostgreSQL