Dialect parity between GoogleSQL and PostgreSQL

The following features are not supported by PostgreSQL-dialect databases.

• Protocol buffer data type. As an alternative, you can store serialized protocol buffers as the PostgreSQL BYTEA type.
• TABLESAMPLE operator
• The following columns in SPANNER_SYS statistics tables:
  • Transaction statistics: TOTAL_LATENCY_DISTRIBUTION and OPERATIONS_BY_TABLE
  • Query statistics: LATENCY_DISTRIBUTION
  • Lock Statistics: SAMPLE_LOCK_REQUESTS

PostgreSQL-dialect databases support the PostgreSQL JSONB type, which is equivalent to GoogleSQL JSON type in functionality.

What's next

• Learn more about Spanner's PostgreSQL language support.
• Learn more about Unsupported PostgreSQL data types.