The page has been translated by Gen AI.
Extension Use
PostgreSQL(DBaaS) Extension usage
Note
You can view the list of extensions included in each PostgreSQL version on the PostgreSQL official page.
You can view the list of extensions that can be installed in the current database with the SQL statement below.
SQL> select * from pg_available_extensions;
PostgreSQL (DBaaS) includes the following items in addition to the default extensions for each version.
| Extension name | Explanation |
|---|---|
| pgaudit | Provides detailed audit logging at the session and object level |
| pg_cron | A scheduler that can schedule jobs using cron syntax within the database. |
| pg_hint_plan | Provides a feature to apply hint clauses to SQL execution plans. |
| pgvector | Provides vector data types and AI vector operation features such as similarity search. |
| postgis | GIS (Geographic Information System) provides spatial object storage and spatial query functionality |
Table. PostgreSQL (DBaaS) Extension additional installation items
If you need to install additional extensions beyond the items above, refer to Support Center > Inquiry and contact us.
- After a request is received, we will review it and proceed with installation. Please note that some extensions may not function properly during replica configuration and recovery.