Online Documentation for Advanced Data Export for RAD Studio VCL

Postgresql


Delphi type

SQL data type

ftSmallint

SMALLINT

ftInteger, ftWord, ftAutoInc, ftReference

INTEGER

ftLargeint

BIGINT

ftBoolean

BOOLEAN

ftFloat

DOUBLE PRECISION

ftCurrency, ftBCD, ftFMTBcd

NUMERIC(20,4)

ftDate

DATE

ftTime

TIME

ftDateTime, ftTimeStamp

TIMESTAMP

ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftBytes, ftVarBytes,ftBlob, ftArray, ftOraBlob, ftDataSet

BYTEA

ftWideString, ftMemo, ftFmtMemo, ftGraphic, ftADT, ftOraClob, ftVariant, ftInterface, ftIDispatch, ftGuid

TEXT

 

For the rest of types the size of a field is checked. If the field size is less than 255 chars then it is converted into VARCHAR. Otherwise, into BLOB.