This page describes the PostgreSQL extensions and lists the extensions supported by Cloud SQL.
PostgreSQL provides a way to extend the functionality of your database by bundling together multiple SQL objects into a single package that can be added or removed as a unit.
How you use PostgreSQL extensions
You must install an extension before you use it. To install an extension, you use the CREATE EXTENSION command with the psql tool. For information about using a specific extension, see the documentation for that extension.
You cannot create your own extensions with Cloud SQL. You can install only extensions supported by Cloud SQL. To request support for an extension, start a thread on the Cloud SQL Discussion group.
PostgreSQL extensions supported by Cloud SQL
Cloud SQL supports many of the standard PostgreSQL extensions:
The PostGIS 2.3 extension family is supported for Cloud SQL. This extension family includes the following extensions:
For more information about installing the PostGIS extension family, see PostGIS Installation.
Data type extensions
|lo||Support for managing Large Objects (also called LOs or BLOBs).|
|plpgsql||A loadable procedural language used to create SQL functions and trigger procedures that execute as a block on the server.|
|fuzzystrmatch||Provides several functions to determine similarities and distance between strings.|
|pg_buffercache||Provides a means for examining what's happening in the shared buffer cache in real time.|
|pg_prewarm||Provides a convenient way to load relation data into either the operating system buffer cache or the PostgreSQL buffer cache.|
|pg_stat_statements||Provides a means for tracking execution statistics of all SQL statements executed.|
|pgcrypto||Provides cryptographic functions for PostgreSQL.|
|pgrowlocks||Provides row locking information for the specified table.|
|sslinfo||Provides information about the SSL certificate that the current client provided when it connected to the instance.|