Supported Extensions for OCI Database with PostgreSQL

OCI Database with PostgreSQL supports the following extensions.

• btree_gin
• btree_gist
• citext
• cube
• dict_int*
• fuzzystrmatch
• hstore
• intarray
• isn
• lo
• ltree
• pg_trgm
• pgcrypto
• plpgsql
• pg_stat_statements**
• seg
• tablefunc*
• tcn
• tsm_system_rows
• tsm_system_time
• unaccent*
• uuid-ossp

^*Not all functionality can be enabled for this extension.
^**There's currently a known issue preventing this extension from being created.

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

Stored Procedure Support

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