When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with a PostgreSQL database.
PostgreSQL Data Type |
Spotfire Data Type |
Comment |
BYTEA |
Binary |
|
GEOMETRY |
Binary |
Not supported in Custom Queries. |
BOOL |
Boolean |
|
MONEY |
Currency |
|
DATE |
Date |
|
TIMESTAMP |
DateTime |
|
TIMESTAMPTZ |
DateTime |
|
BIT |
Integer |
Not supported in Custom Queries. |
INT2 |
Integer |
|
INT4 |
Integer |
|
SMALLSERIAL |
Integer |
|
SERIAL |
Integer |
|
INT8 |
LongInteger |
|
BIGSERIAL |
LongInteger |
|
FLOAT8 |
Real |
|
FLOAT4 |
SingleReal |
|
BPCHAR |
String |
|
VARCHAR |
String |
|
TEXT |
String |
|
INTERVAL |
String |
Not supported in Custom Queries.
It might not be possible to access INTERVAL data from some versions of Brytlyt. |
CIDR |
String |
|
INET |
String |
|
MACADDR |
String |
|
XML |
String |
|
TIME |
Time |
|
TIMETZ |
Time |
Not supported in Custom Queries. |
NUMERIC(p,s) |
When p <= 9 and s = 0: Integer/Int When 9 < p <= 18 and s = 0: LongInteger/Long When p <= 15: Real/Double Else: Currency/Decimal |
|
Any other data types are not supported.