The page has been translated by Gen AI.
Using Extensions
PostgreSQL(DBaaS) Extension usage
Note
The list of extensions included in each version of PostgreSQL can be found on the PostgreSQL official page.
The list of extensions that can be installed in the current database can be checked with the following SQL statement.
SQL> select * from pg_available_extensions;
PostgreSQL(DBaaS) has the following additional installation items outside of the default extension by version:
| Extension name | description |
|---|---|
| pgaudit | provides detailed audit logging functionality at the session and object level |
| pg_cron | a scheduler that allows job scheduling with cron syntax within the database |
| pg_hint_plan | Provides a feature to apply hint clauses to SQL execution plans |
| pgvector | Vector data type and similarity search, etc. AI vector operation function provided |
| postgis | GIS (Geographic Information System) provides spatial object storage and spatial query functionality |
Table. PostgreSQL(DBaaS) Extension Additional Installation Items
In addition to the above items, if additional Extension installation is required, please refer to Support Center > 문의하기 and inquire.
- Once the inquiry is received, we will proceed with the installation after review. Please note that some Extensions may not work normally during Replica configuration and recovery.