PostgresSQL / PostGIS Data Type Equivalence Table - MapInfo_Pro - 2023

Integers

bigint

Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).

Double Precision

double precision floating-point number

int2

Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767).

int4

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).

int8

Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).

int

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).

Serial/Serial4

auto incrementing four-byte integer

Serial8

auto incrementing integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).

smallint

Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767).

Bit

bit

Integer with a 1 and 0

bit varying

Integer of 1 and 0

Varbit

Integer of 1 and 0

Decimal and Numeric

decimal

Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1.

numeric

Functionally equivalent to a decimal

Money

money

Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.

Approximate Numerics

Float4

Single precision floating-point number

Float8

double precision floating-point number

real

Floating precision number data from -3.40E + 38 through 3.40E + 38.

Date and Time

date

Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.

Time

Time of day

Timestamp

Date and time

Character Strings

Bytea

binary data ("byte array")

Character varying

variable-length character string

Character

fixed-length character string

char

fixed-length character string

text

variable-length character string

varchar

variable-length character string

Boolean

Boolean

A field of 1 for true, 0 for false or T o F