When you are configuring 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 type mappings applicable when working with a PostgreSQL database.
PostgreSQL Database Type |
Spotfire Data Type |
Supported |
BIT |
Integer |
Yes Note: Not supported in Custom Queries. |
INT2 |
Integer |
Yes |
INT4 |
Integer |
Yes |
FLOAT4 |
SingleReal |
Yes |
FLOAT8 |
Real |
Yes |
INT8 |
LongInteger |
Yes |
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 |
Yes |
MONEY |
Currency |
Yes |
BOOL |
Boolean |
Yes |
BPCHAR |
String |
Yes |
VARCHAR |
String |
Yes |
TEXT |
String |
Yes |
DATE |
Date |
Yes |
TIME |
Time |
Yes |
TIMETZ |
Time |
Yes Note: Not supported in Custom Queries. |
TIMESTAMP |
DateTime |
Yes |
TIMESTAMPTZ |
DateTime |
Yes |
INTERVAL |
TimeSpan |
Yes Note: Not supported in Custom Queries. |
BYTEA |
Binary |
Yes |
CIDR |
String |
Yes |
INET |
String |
Yes |
MACADDR |
String |
Yes |
XML |
String |
Yes |
GEOMETRY |
Binary |
Yes Note: Not supported in Custom Queries. |
Any other data types are not supported.