-
Notifications
You must be signed in to change notification settings - Fork 1
converter postgresql mapping
wz2cool edited this page May 6, 2019
·
2 revisions
| Mysql | postgresql | comment |
|---|---|---|
| BIT | BIT | |
| TINYINT | SMALLINT | |
| SMALLINT | SMALLINT | |
| MEDIUMINT | INT | |
| INT | INT | |
| INTEGER | INT | |
| BIGINT | BIGINT | |
| FLOAT | NUMERIC | |
| DOUBLE | NUMERIC | |
| DECIMAL | NUMERIC | |
| DATE | DATE | |
| DATETIME | TIMESTAMP | |
| TIMESTAMP | TIMESTAMP | |
| TIME | TIME | |
| VARCHAR | VARCHAR | |
| CHAR | VARCHAR | |
| TINYBLOB | BYTEA | |
| BLOB | BYTEA | |
| MEDIUMBLOB | BYTEA | |
| LONGBLOB | BYTEA | |
| TINYTEXT | TEXT | |
| TEXT | TEXT | |
| MEDIUMTEXT | TEXT | |
| LONGTEXT | TEXT |