data type Migration from MySQL to PostgreSQL
2016-04-08 15:24 DataBases 阅读(309) 评论(0) 编辑 收藏 举报MySQL PostgreSQL
tinyint smallint
smallint smallint
mediumint integer
int integer
bigint bigint
longtext text
char char
varchar varchar
binary(n) bytea
varbinary(n) bytea
tinytext text
text text
date date
time time[without time zone]
datetime timestamp[without time zone]
timestamp timestamp[without time zone]
double numeric
auto_increment serial
Key words
KEY INDEX
Linux vim Character substitution
:%s/str1/str2/g 用str2替换行中所有的str1
:%s/str1/str2/gi 用str2替换行中所有的str1不区分大小写
把str2替换为空格就等同于删除str1