This page summarizes PostgreSQL language support in Cloud Spanner.
Cloud Spanner provides PostgreSQL language support by expressing Cloud Spanner database functionality through a subset of open-source PostgreSQL language constructs, with extensions added to support Cloud Spanner functionality like interleaved tables and hinting.
For detailed information about this support, refer to these pages:
- Lexical structure and syntax describes how to form valid PostgreSQL statements.
- Data definition (DDL)
defines the syntax of DDL statements like
CREATE DATABASE
andCREATE TABLE
. - Data manipulation (DML)
defines the syntax of DML statements like
INSERT
andUPDATE
. - Queries
defines the syntax of the
SELECT
statement. - Data types describes the data types that Cloud Spanner supports.
- Functions describes the functions that Cloud Spanner supports.
Cloud Spanner does not currently support several open-source PostgreSQL features, including the following:
- Ecosystem clients
- Stored procedures
- Triggers
- SERIAL
- Privileges
- Fine-grained concurrency control
- Sequences
- SAVEPOINT
- Transactional DDL
- Partial indexes
- Extensions
- Foreign data wrappers
- User-defined data types, functions and operators