An overview of SQL Server data types and their PostgreSQL equivalents
SQLServer 与 PostgreSQL 字段对应关系
MSSQL | PGSQL |
---|---|
char | char / text |
nchar | char / text |
varchar | varchar / text |
nvarchar | varchar / text |
xml | text |
int | integer |
bigint | bigint |
bit | boolean |
uniqueidentifier | uuid |
hierarchyid | bytea |
geography | bytea |
tinyint | smallint |
float | float |
real | real |
double | double precision |
numeric | numeric |
decimal | numeric |
money | numeric |
smallmoney | numeric |
binary | bytea |
varbinary | bytea |
image | bytea |
datetime | timestamptz |
datetime2 | timestamptz |