MSServer转Postgresql类型对应表

//  sqlserver           to        postgresql type
// "bigint","bigint"
//	"binary","bytea"
//	"bit","boolean"
//	"char","char"
//	"datetime","timestamp"	
//	"decimal","numeric"
//	"float","double precision"
//	"image","bytea"
//	"int","integer"
//	"money","numeric(19,4)"
//	"nchar","varchar"
//	"ntext","text"
//	"numeric","numeric"
//	"nvarchar","varchar"
//	"real","real"
//	"smalldatetime","timestamp"
//	"smallint","smallint"
//	"smallmoney","numeric(10,4)"
//	"text","text"
//	"timestamp","bigint"
//	"tinyint","smallint"
//	"uniqueidentifier","uniqueidentifier"
//	"varbinary","bytea"
//	"varchar","varchar"

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!