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

8 votes112 views1 answer
Oracle current date plus 1 month
SQL
0 vote148 views1 answer
How to connect to mysql in ef 6
SQL
1 vote134 views1 answer
Tsql random number
SQL
3 votes144 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
4 votes133 views2 answers
Sql table
SQL
4 votes96 views1 answer
And or sql order of operations
SQL
0 vote302 views1 answer
Current month transactions in mysql
SQL
0 vote143 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
19 votes141 views6 answers
Laravel sql query
SQL
0 vote145 views1 answer
Sql server size of every table in a db
SQL