Provider Information PostgreSQL data type mapping: int8 (I8) (size 19) (isfixedlength) char (BOOL) (size 1) (isfixedlength) char (STR) (size 254) (isfixedlength) (max. length) date (BYTES) (size 10) date (DBDATE) (size 10) (isfixedlength) numeric (NUMERIC) (size 28) (isfixedlength) (precision, scale) float8 (R8) (size 15) (isfixedlength) float8 (R8) (size 15) (isfixedlength) int4 (I4) (size 10) (isfixedlength) lo (BYTES) (size 4294967292) (islong) text (STR) (size 8190) numeric (NUMERIC) (size 28) (isfixedlength) (precision, scale) float4 (R4) (size 7) (isfixedlength) int2 (I2) (size 5) (isfixedlength) time (BYTES) (size 8) timestamptz (BYTES) (size 19) time (DBTIME) (size 8) (isfixedlength) timestamptz (DBTIMESTAMP) (size 19) (isfixedlength) int2 (I1) (size 5) (isfixedlength) bytea (BYTES) (size 254) varchar (STR) (size 254) (max. length) This list can be created for any initialized provider, by choosing [Admin/Information] and copying from the Results tab.