Writing PostgreSQL Extensions in C is Fun — It depends on your definition of fun but it’s not quite as difficult as I’d assumed. This post walks through the basic steps to get started. I also think reading the code of simple, but complete, extensions such as count_distinct is useful if you wish to pursue this.
Appears in lists (1)
More like this (3)
A Look at Embedded SQL in C for Postgres with ecpg — A quick look at...A Look at Embedded SQL in C for Postgres with ecpg — A quick look at what is generously called a ‘vintage technology’ (i.e. old fashioned) where you write SQL directly inline within, say, a C program and compile it to handle all the database work behind the scenes. I’d never seen this style of programming before, so it’s interesting even if I’ll never use it.
How to Create, Test and Debug an Extension Written in C for Postgres — Most of...How to Create, Test and Debug an Extension Written in C for Postgres — Most of us aren’t ever going to build our own Postgres extensions, but it’s always good to know that we can.
Retroactively Adding Binary I/O to a Type in Postgres