PostgreSQL Data Types
The following table shows Magic xpa equivalents for PostgreSQL database data types.
|
|
|
|
|
|
|
CHAR(n)
|
Unicode
|
ZUnicode
|
(n*2)+2
|
n
|
|
VARCHAR2(n)
|
Unicode
|
ZUnicode
|
(n*2)+2
|
n
|
|
BIGINT
|
Numeric
|
String Number
|
20
|
19
|
|
INTEGER
|
Numeric
|
Signed Integer
|
4
|
10
|
|
SMALLINT
|
Numeric
|
Signed Integer
|
2
|
5
|
|
DOUBLE PRECISION
|
Numeric
|
Float
|
8
|
10.3
|
|
REAL
|
Numeric
|
Float
|
8
|
10.3
|
|
NUMERIC(n, p)
|
Numeric
|
Float if n <= 15, String Number if n >=16
|
8 if Float, n + 1 if String
|
n-p, p
|
|
BOOLEAN
|
Logical
|
Integer logical
|
1
|
5
|
|
DATE
|
Date
|
String Date
|
8
|
##/##/####
|
|
TIME
|
Time
|
String Time
|
6
|
HH:MM:SS
|
|
TEXT
|
Blob
|
Unicode
|
|
|
|
BYTEA
|
Blob
|
Binary
|
|
|
Since version: 4.6
