Welcome to the Postgres Extension Tutorial. This comprehensive tutorial is designed to provide a step-by-step guide to PostgreSQL extension development. Whether you're new to PostgreSQL or extension development, this tutorial assumes only a basic knowledge of Postgres and the target programming language. It covers various aspects of creating, managing, and distributing extensions for PostgreSQL.
After completing this tutorial, you'll have a strong foundation in PostgreSQL extension development, and you can explore advanced topics in PostgreSQL or contribute to the extension ecosystem.
- 1.1. Introduction to PostgreSQL Extensions
- 1.2. Setting Up Your Environment
- 1.3. Basic Extension Components
- 2.1. Creating the Extension Directory
- 2.2. Writing the Control File
- 2.3. Creating the Extension SQL File
- 2.4. Writing the Makefile
- 2.5. Building and Installing the Extension
- 2.6. Creating and Implementing the Extension in PostgreSQL
- 3.1. Introduction to Regression Testing
- 3.2. Creating Regression Test Scripts
- 3.3. Running Regression Tests