Summary

As C is the language that PostgreSQL itself is written in, it is very hard to draw a distinction on what is an extension function using a defined API and what is hacking PostgreSQL itself.

Some of the topics that we did not touch at all were:

  • Creating new installable types from scratch—see contrib/hstore/ for a full implementation of a new type.
  • Creating new index methods—download an older version of PostgreSQL to see how full text indexing support was provided as an add-on.
  • Implementing a new PL/* language—search for pl/lolcode for a language, the sole purpose of which is to demonstrate how a PostgreSQL's PL/* language should be written (see http://pgfoundry.org/projects/pllolcode/). You may also want to check out the source code for PL/Proxy ...

Get PostgreSQL Server Programming - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial