The PostgreSQL language in Cloud Spanner

This page summarizes PostgreSQL language support in the preview release of the PostgreSQL interface feature.

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 in the preview release of the PostgreSQL interface feature, 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