Oracle Cloud Infrastructure Documentation

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 certain extensions must be enabled by administrators through custom configurations. After a configuration with enabled extensions is associated with a database system, database admin users can manage those extensions when connected to the database.

For more information, see Enabling Extensions for a Database. To find out which extensions are enabled in a particular configuration, see Getting Custom Configuration Details.

Extension Enablement
amcheck Must be enabled in configuration
btree_gin Available by default
btree_gist Available by default
citext Available by default
cube Available by default
dblink Must be enabled in configuration
dict_int* Available by default
fuzzystrmatch Available by default
hstore Available by default
intarray Available by default
isn Available by default
lo Available by default
ltree Available by default
pg_cron Must be enabled in configuration
pg_repack Must be enabled in configuration
pg_squeeze Must be enabled in configuration
pg_stat_statements Must be enabled in configuration
pg_trgm Available by default
pgaudit Must be enabled in configuration
pgbuffercache Must be enabled in configuration
pgcrypto Available by default
pgrowlocks Must be enabled in configuration
pgstattuple Must be enabled in configuration
pgvector Must be enabled in configuration
plpgsql Available by default
postgres_fdw Must be enabled in configuration
seg Available by default
tablefunc* Available by default
tcn Available by default
tsm_system_rows Available by default
tsm_system_time Available by default
unaccent* Available by default
uuid-ossp Available by default

*Not all functionality can be enabled for this extension.

Tip

For more information about extensions, see the related PostgreSQL documentation.

Stored Procedure Support

OCI Database with PostgreSQL supports the PL/pgSQL stored procedure language.