contribdirectory of the PostgreSQL distribution. These include porting tools, analysis utilities, and plug-in features that are not part of the core PostgreSQL system, mainly because they address a limited audience or are too experimental to be part of the main source tree. This does not preclude their usefulness.
contribdirectory of a configured source tree; or to build and install just one selected module, do the same in that module's subdirectory. Many of the modules have regression tests, which can be executed by running:
template1so that the extension will be copied into subsequently-created databases by default.
CREATE EXTENSIONmust be run by a database superuser, unless the module is considered “trusted”, in which case it can be run by any user who has
CREATEprivilege on the current database. Modules that are trusted are identified as such in the sections that follow. Generally, trusted modules are ones that cannot provide access to outside-the-database functionality.
CREATE EXTENSIONcommand. By default, the objects will be placed in your current creation target schema, which in turn defaults to