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 vote133 views1 answer
Get cpu details sql
SQL
2 votes140 views4 answers
2nd highest salary in mysql
SQL
1 vote128 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote127 views1 answer
Cast as decimal postgresql
SQL
5 votes118 views5 answers
Sqlite install python
SQL
0 vote120 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
3 votes153 views2 answers
Wp do sql query from function
SQL
3 votes121 views2 answers
Oracle grants
SQL
3 votes128 views3 answers
Postgresql random number
SQL
13 votes125 views2 answers
Oracle select into and inner join
SQL