The PostgreSQL language in Cloud Spanner

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:

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