Connecting to Cloud SQL with Private Google access isn't supported.
Differences between standard PostgreSQL and Cloud SQL for PostgreSQL
In general, the PostgreSQL functionality provided by a Cloud SQL
instance is the same as the functionality provided by a locally-hosted
PostgreSQL instance. However, there are a few differences between a standard
PostgreSQL instance and a Cloud SQL instance.
Unsupported features for Cloud SQL for PostgreSQL
Any feature that requiresSUPERUSERprivileges with the following exceptions:
If you are assigned to thecloudsqlsuperuserrole, then you can performCREATE CASTandDROP CASTstatements. For more information, seeSuperuser restrictions and privileges.
TheWITHOUT FUNCTIONcast method.
Custom background workers.
Thepsqlclient in Cloud Shell doesn't support operations that
require a reconnection, such as connecting to a different database using the\ccommand.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-28 UTC."],[],[],null,["# Cloud SQL for PostgreSQL features\n\n\u003cbr /\u003e\n\n[MySQL](/sql/docs/mysql/features \"View this page for the MySQL database engine\") \\| PostgreSQL \\| [SQL Server](/sql/docs/sqlserver/features \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\nThis page describes the major features and capabilities of Cloud SQL for PostgreSQL. Cloud SQL is also available for [MySQL](/sql/docs/mysql/features) and [SQL Server](/sql/docs/sqlserver/features).\n\n\u003cbr /\u003e\n\n| **Note:** For information about the supported versions of database engines, see [Database versions and version policies](/sql/docs/postgres/db-versions).\n\nPostgreSQL features by Cloud SQL editions\n-----------------------------------------\n\nFor more information about the features for each edition of Cloud SQL for PostgreSQL,\nsee [Introduction to Cloud SQL editions](/sql/docs/postgres/editions-intro).\n\nPostgreSQL feature support for Cloud SQL\n----------------------------------------\n\n- Fully managed PostgreSQL databases in the cloud.\n- Instances available in the Americas, EU, Asia, and Australia. See [all\n locations where you can create Cloud SQL\n instances](/sql/docs/postgres/locations).\n- Supports migration from source databases to Cloud SQL destination databases using [Database Migration Service\n (DMS)](/database-migration/docs/postgres/configure-source-database).\n- Customer data encrypted on Google's internal networks and in database tables, temporary files, and backups.\n- Support for secure external connections with the Cloud SQL Auth Proxy or with the SSL/TLS protocol.\n- Data replication between multiple zones with automatic failover.\n- Import and export databases using SQL dump files.\n- Support for PostgreSQL client-server protocol and standard PostgreSQL connectors.\n- Automated backups, on-demand backups, and point-in-time recovery.\n- Instance cloning.\n- Integration with Google Cloud Observability logging and monitoring.\n- Support for multiple [PostgreSQL versions](/sql/docs/postgres/db-versions).\n- Logical replication\n\nSupported PostgreSQL extensions for Cloud SQL\n---------------------------------------------\n\nCloud SQL supports many PostgreSQL extensions. For a complete list of these\nextensions, see [Configure PostgreSQL\nextensions](/sql/docs/postgres/extensions).\n\nSupported PostgreSQL procedural languages for Cloud SQL\n-------------------------------------------------------\n\nCloud SQL supports the [`PL/pgSQL` SQL procedural\nlanguage](https://www.postgresql.org/docs/current/static/plpgsql.html).\n\nSupported languages for Cloud SQL for PostgreSQL\n------------------------------------------------\n\nYou can use Cloud SQL with App Engine applications running in the\nflexible environment that are written in:\n\n- C#\n- Go\n- Java\n- Node.js\n- PHP\n- Python\n- Ruby\n\nYou can also use Cloud SQL with external applications using the standard\nPostgreSQL client-server protocol.\n\nHow you can connect to Cloud SQL for PostgreSQL instances\n---------------------------------------------------------\n\nYou can connect to a Cloud SQL instance from:\n\n- A `psql` client. [Learn more](/sql/docs/postgres/connect-admin-ip).\n- Third-party tools that use the standard PostgreSQL client-server protocol.\n- External applications. [Learn\n more](/sql/docs/postgres/connect-external-app).\n- App Engine applications. [Learn\n more](/sql/docs/postgres/connect-app-engine).\n- Applications running on Compute Engine. [Learn\n more](/sql/docs/postgres/connect-compute-engine).\n- Applications running on Google Kubernetes Engine. [Learn\n more](/sql/docs/postgres/connect-kubernetes-engine).\n- Cloud Run functions. [Learn more](/sql/docs/postgres/connect-functions).\n - Cloud Run. [Learn more](/sql/docs/mysql/connect-run).\n\nConnecting to Cloud SQL with Private Google access isn't supported.\n\nDifferences between standard PostgreSQL and Cloud SQL for PostgreSQL\n--------------------------------------------------------------------\n\nIn general, the PostgreSQL functionality provided by a Cloud SQL\ninstance is the same as the functionality provided by a locally-hosted\nPostgreSQL instance. However, there are a few differences between a standard\nPostgreSQL instance and a Cloud SQL instance.\n\n### Unsupported features for Cloud SQL for PostgreSQL\n\n- Any feature that requires `SUPERUSER` privileges with the following exceptions:\n\n - You can use the `CREATE EXTENSION` statement only for [supported extensions](#extensions).\n\n - If you are assigned to the `cloudsqlsuperuser` role, then you can perform `CREATE CAST` and `DROP CAST` statements. For more information, see [Superuser restrictions and privileges](/sql/docs/postgres/users#superuser-restrictions-and-privileges).\n\n- The `WITHOUT FUNCTION` cast method.\n\n- Custom background workers.\n\n- The `psql` client in Cloud Shell doesn't support operations that\n require a reconnection, such as connecting to a different database using the\n `\\c` command.\n\n- Low-Level Virtual Machine (LLVM) Just-in-Time (JIT) compilation.\n\n### Notable differences between PostgreSQL and Cloud SQL for PostgreSQL\n\n- Some PostgreSQL options and parameters aren't enabled for editing as [Cloud SQL flags](/sql/docs/postgres/flags).\n\n To request the addition of a configurable Cloud SQL flag, use the [Cloud SQL for PostgreSQL Forum](https://www.googlecloudcommunity.com/gc/forums/filteredbylabelpage/board-id/cloud-database/label-name/cloud%20sql%20for%20postgres)."]]
