| BigQuery standard data type | BigQuery legacy data type | PostgreSQL equivalent | Supported in bigquery_fdw? |
|---|---|---|---|
| STRING | STRING | text | ✓ |
| BYTES | BYTES | bytea? | ✗ |
| INT64 | INTEGER | bigint | ✓ |
| FLOAT64 | FLOAT | double precision | ✓ |
| BOOL | BOOLEAN | bool | ✓ |
| (deprecated) | RECORD | ? | ✗ |
| TIMESTAMP | TIMESTAMP | timestamp | ✓ |
| DATE | DATE | date | ✓ |
| TIME | TIME | time | ✓ |
| DATETIME | DATETIME | timestamp | ✓ |