Microsoft SQL Server Source Data Type | PostgreSQL Target Data Type |
|---|---|
bigint | bigint |
binary(size), 1 <= size <= 8000 | bytea |
bit | boolean |
char(size), 1 <= size <= 8000 | character varying(size), 1 <= size <= 8000 |
date | date |
datetime | timestamp(3) |
datetime2(precision), 0 <= p <= 6 | timestamp(precision), 0 <= p <= 6 |
datetime2(7) | timestamp(6) |
datetimeoffset(precision), 0 <= p <= 6 | timestamptz(precision), 0 <= p <= 6 |
datetimeoffset(7) | timestamptz(6) |
decimal(p,s), 1 <= p <= 38, 1 <= s <= 38 | numeric(p,s), 1 <= p <= 38, 1 <= s <= 38 |
decimal(p,s), 1 <= p <= 38, s = 0 | numeric(p), 1 <= p <= 38 |
float | double precision |
geography | bytea |
geometry | bytea |
hierarchyid | bytea |
image | bytea |
int | integer |
money | decimal(19,4) |
nchar(size), 1 <= size <= 4000 | character varying(size), 2 <= size <= 8000 |
ntext | text |
numeric(p,s), 1 <= p <= 38, s = 0) | numeric(p), 1 <= p <= 38 |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | number(p,s), 1 <= p <= 38, 0 <= s <= 38 |
nvarchar(size), 1 <= size <= 4000 | character varying(size), 2 <= size <= 8000 |
real | real |
smalldatetime | timestamp(0) |
smallint | smallint |
smallmoney | decimal(10,4) |
sql_variant | bytea |
text | text |
time(precision), 0 <= p <= 6 | time(precision), 0 <= p <= 6 |
time(7) | time(6) |
timestamp(8) | bytea |
tinyint | smallint |
uniqueidentifier | uuid |
varbinary(size), 1 <= size <= 8000 | bytea |
varchar(size), 1 <= size <= 8000 | character varying (size), 1 <= size <= 8000 |
varchar(max) | text |
xml | xml |