Supported PostgreSQL Extensions for OCI Database with PostgreSQL
All OCI Database with PostgreSQL database systems support extensions, many of which are enabled by default. Most extensions supported by OCI Database with PostgreSQL are available for immediate use, but some require an administrator to enable the extension through a custom configuration.
For more information, see:
For more information about extensions, see the related PostgreSQL documentation.
Default Extensions
The following extensions are enabled by default and available for use when connected to the database:
btree_ginbtree_gistcitextcubedict_int*fuzzystrmatchhstoreintarrayisnloltreepg_trgmpgcryptoplpgsqlsegtablefunc*tcntsm_system_rowstsm_system_timeunaccent*uuid-ossp
*Not all functionality can be enabled for this extension.
Administrator-enabled Extensions
The following extensions must be enabled by the database system admin through custom configurations. After a configuration with administrator-enabled extensions is associated with a database system, database admin users can manage those extensions when connected to the database. The following PostgreSQL extensions can be enabled by administrators:
amcheckdblinkpg_repackpg_squeezepg_stat_statementspgbuffercachepgrowlockspgstattuplepgvectorpostgres_fdw
To see which extensions are enabled in a particular configuration, see Getting Custom Configuration Details.
Stored Procedure Support
OCI Database with PostgreSQL supports the PL/pgSQL stored procedure language.