Extension management

Enough theory! It's now time to see how an extension is implemented. This chapter will start by implementing an extension from scratch. We will then look at how to provide upgrades to an existing extension.

Creating and removing extensions

Extensions are installed on a per-database basis. The control and script file must be available to the cluster and the extension must be loaded into every database in which it is required. An extension is created by means of the CREATE EXTENSION command, which allows us to specify the version and the schema (if the extension is relocatable). If no version is specified, the extension will be installed with the default version specified in its control file. Similarly...