PostgreSQL Extensions

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, add a Me, too! vote for its issue in the Issue Tracker (look under Cloud SQL) or create a new issue.

PostgreSQL extensions supported by Cloud SQL

Cloud SQL supports many of the standard PostgreSQL extensions:

PostGIS

The PostGIS 2.3 extension family is supported for Cloud SQL. This extension family includes the following extensions:

  • postgis
  • postgis_tiger_geocoder
  • postgis_topology

For more information about installing the PostGIS extension family, see PostGIS Installation.

Data type extensions

Extension Description
hstore Implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value.
lo Support for managing Large Objects (also called LOs or BLOBs).

Language extensions

Extension Description
plpgsql A loadable procedural language used to create SQL functions and trigger procedures that execute as a block on the server.

Miscellaneous extensions

Extension Description
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.

Send feedback about...

Cloud SQL for PostgreSQL