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

• 5.1. Updating Your Extension
  • 5.1.1. ALTER EXTENSION method
  • 5.1.2. DROP EXTENSION method

• 6.1 Versioning
• 6.2. README.md
• 6.3. docfile
• 6.4. Changelog and Versioning

• 7.1. Using PGXN
• 7.2. Using package managers

• 8.1. Procedural Languages for Extension Creation

  • 8.1.1. Using PL/pgSQL
  • 8.1.2. Using PL/Python

• 8.2. External Languages for Extension Creation

  • 8.2.1. Using C(External Language) to extend Postgres

• 8.3. Extending PostgreSQL with pg_sample_ext

  • 8.3.1. Creating a Custom Function
  • 8.3.2. Creating and using Custom Data Types
    • 8.3.2.1. Using CREATE TYPE
    • 8.3.2.2. Using CREATE DOMAIN
  • 8.3.3. Creating and using Custom Postgres Operators