The PostgreSQL language in Spanner

This page summarizes PostgreSQL language support in Spanner.

Spanner provides PostgreSQL language support by expressing Spanner database functionality through a subset of open source PostgreSQL language constructs, with extensions added to support Spanner functionality like interleaved tables and hinting.

For detailed information about this support, refer to these pages:

Spanner does not currently support several open source PostgreSQL features, including the following:

  • Stored procedures
  • Triggers
  • SERIAL
  • Fine-grained concurrency control
  • SAVEPOINT
  • Transactional DDL
  • Partial indexes
  • Extensions
  • Foreign data wrappers
  • User-defined data types, functions and operators