Data types mysql vs postgresql

MySQL                   PostgreSQL          SQLite

TINYINT                 SMALLINT            INTEGER
SMALLINT                SMALLINT
MEDIUMINT               INTEGER
BIGINT                  BIGINT
BIT                     BIT                 INTEGER
_______________________________________________________

TINYINT UNSIGNED        SMALLINT            INTEGER
SMALLINT UNSIGNED       INTEGER
MEDIUMINT UNSIGNED      INTEGER
INT UNSIGNED            BIGINT
BIGINT UNSIGNED         NUMERIC(20)
_______________________________________________________

DOUBLE                  DOUBLE PRECISION    REAL
FLOAT                   REAL                REAL
DECIMAL                 DECIMAL             REAL
NUMERIC                 NUMERIC             REAL
_______________________________________________________

BOOLEAN                 BOOLEAN             INTEGER
_______________________________________________________

DATE                    DATE                TEXT
TIME                    TIME
DATETIME                TIMESTAMP
_______________________________________________________

TIMESTAMP DEFAULT       TIMESTAMP DEFAULT   TEXT
NOW()                   NOW()   
_______________________________________________________

LONGTEXT                TEXT                TEXT
MEDIUMTEXT              TEXT                TEXT
BLOB                    BYTEA               BLOB
VARCHAR                 VARCHAR             TEXT
CHAR                    CHAR                TEXT
_______________________________________________________

columnname INT          columnname SERIAL   INTEGER PRIMARY 
AUTO_INCREMENT                              KEY AUTOINCREMENT

Source: stackoverflow.com

Similar codes

0 vote328 views1 answer
Sql alchemy escape ; in insert statement
SQL
3 votes333 views2 answers
Laravel tosql with bindings
SQL
12 votes315 views6 answers
Between in sql
SQL
0 vote328 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote372 views1 answer
Mysql convert charset
SQL
1 vote315 views1 answer
Show structure of table in sql
SQL
13 votes297 views2 answers
Sqlite rename column
SQL
13 votes338 views1 answer
Views in sql
SQL
0 vote297 views1 answer
Mysql error codeigniter
SQL
5 votes328 views3 answers
Mysql update field from one table to another
SQL