spi

A contrib module providing examples of Server Programming Interface (SPI) usage

spi is a contrib module providing examples of Server Programming Interface (SPI) usage.

spi was added in PostgreSQL 6.2 (initial commit b6f348cd).

As of PostgreSQL 12, it contains following example extensions:

  • refinc - functions for implementing referential integrity
  • autoinc -functions for autoincrementing fields
  • insert_username - functions for associating table changes with users
  • moddatetime - functions for tracking last modification time

These extensions are primarily intended to provide examples of SPI usage (particularly refinc, whose functionality has long since been included in core PostgreSQL).

Change history

  • PostgreSQL documentation: spi

Categories

Application interface, Coding example, Contrib module, Extension, PostgreSQL internals

See also

Server Programming Interface (SPI)