Skip to main content

Type


숫자

TypeByteMySQLPostgreSQL
integer1tinyint-
integer2smallintsmallint
integer3mediumint-
integer4intinteger
integer8bigintbigint
float4floatreal
float8doubledouble precision
floatnumericnumeric

문자

TypeMySQLPostgreSQL
varchar(n)character varying(n), varchar(n)

Bytes

TypeMySQLPostgreSQL
varbinary(n)bytea

날짜

TypeMySQLPostgreSQL
datedate
timetime
datetimetimestamp
timestamptimestamp