Provider Information PostgreSQL data type mapping: int8 (I8) (size 19) (isfixedlength) char (BOOL) (size 1) (isfixedlength) char (STR) (size 255) (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 26) time (DBTIME) (size 8) (isfixedlength) timestamptz (DBTIMESTAMP) (size 26) (isfixedlength) int2 (I1) (size 5) (isfixedlength) bytea (BYTES) (size 255) varchar (STR) (size 255) (max. length) uuid (GUID) (size 37) (isfixedlength) This list can be created for any initialized provider, by choosing [Admin/DBMS data types] and copying from the Results tab.