Extending PostgreSQL Functionality

Cloud automatically installs the following Postgres extensions in your Postgres database:

Before using an extension, you must create the extension (opens in a new tab) in each database in which it will be used. Invoke the following command on the psql command line:

CREATE EXTENSION extension_name;

For example, to create the pgvector extension, use the command:

CREATE EXTENSION vector;

For detailed information about using each extension, visit the project's site links provided in the table above.

To review a list of the installed extensions, you can use the psql command line client to display the shared_preload_libraries parameter setting. To review a list of installed extensions, use the SHOW shared_preload_libraries; command:

accts=# SHOW shared_preload_libraries;
shared_preload_libraries
-------------------------------------------------------------------------------
pg_stat_statements, pg_readonly, pg_failover_slots, spock, vector, postgis-3
(1 row)

Installed extensions are listed in the query result set.