Read Basic Data Type

MicroStrategy uses a SQL query to retrieve information about data types for a list of tables. See Catalog for Columns in a Table for more details.

PostgreSQL has a rich set of native data types available to users. See Data Types on the PostgreSQL site for more details.

The following table shows the build-in general-purpose basic data types. 

PostgreSQL Data type	MicroStrategy Data Type
BIGINT	BIG INTEGER
BIGSERIAL	BIG INTEGER
BIT	BINARY
BIT VARYING	VARBIN
BOOLEAN	BINARY
BYTEA	LONG VARBIN
CHARACTER	CHAR
CHARACTER VARYING	VARCHAR
DATE	DATE
DOUBLE PRECISION	DOUBLE
INTEGER	INTEGER
MONEY	NUMERIC
NUMERIC	DECIMAL
REAL	FLOAT
TEXT	LONG VARCHAR
SMALLINT	INTEGER
SERIAL	INTEGER
SMALLSERIAL	INTEGER
TIMESTAMP WITHOUT TIME ZONE	TIMESTAMP
TIME WITHOUT TIME ZONE	TIME
TIMESTAMP WITH TIME ZONE	TIMESTAMP

See Data Type Awareness for more details on available data types and how MicroStrategy maps data types.