PostgreSQL to Google BigQuery mapping

AutoSync maps PostgreSQL object types to the following Google BigQuery column types:


PostgreSQL object type	Google BigQuery column type
`serial`	`INT64`
`bigserial`	`INT64`
`int2`	`INT64`
`int4`	`INT64`
`int8`	`INT64`
`numeric`	`NUMERIC`
`numeric_without_prec_scale`	`STRING`
`float4`	`FLOAT64`
`float8`	`FLOAT64`
`money`	`FLOAT64`
`bytea`	`BYTES`
`varchar`	`STRING`
`bpchar`	`STRING`
`text`	`STRING`
`cidr`	`STRING`
`inet`	`STRING`
`macaddr`	`STRING`
`macaddr8`	`STRING`
`bit`	`STRING`
`uuid`	`STRING`
`xml`	`STRING`
`json`	`JSON`
`jsonb`	`JSON`
`tsvector`	`STRING`
`tsquery`	`STRING`
`timestamp`	`TIMESTAMP`
`timestamptz`	`TIMESTAMP`
`date`	`DATE`
`time`	`TIME`
`timetz`	`TIME`
`interval`	`STRING`
`point`	`STRING`
`line`	`STRING`
`lseg`	`STRING`
`box`	`STRING`
`path`	`STRING`
`polygon`	`STRING`
`circle`	`STRING`
`geometry`	`JSON`
`array`	`STRING`
`composite`	`STRING`
`range`	`STRING`
`oid`	`INT64`
`pg_lsn`	`STRING`
`bool`	`BOOL`
`char`	`STRING`
`name`	`STRING`
`sl_timestamp`	`TIMESTAMP`