data types mysql vs postgresql

Solutions on MaxInterview for data types mysql vs postgresql by the best coders in the world

Search
showing results for - "data types mysql vs postgresql"
Leanne
03 Jun 2016
1MySQL                   PostgreSQL          SQLite
2
3TINYINT                 SMALLINT            INTEGER
4SMALLINT                SMALLINT
5MEDIUMINT               INTEGER
6BIGINT                  BIGINT
7BIT                     BIT                 INTEGER
8_______________________________________________________
9
10TINYINT UNSIGNED        SMALLINT            INTEGER
11SMALLINT UNSIGNED       INTEGER
12MEDIUMINT UNSIGNED      INTEGER
13INT UNSIGNED            BIGINT
14BIGINT UNSIGNED         NUMERIC(20)
15_______________________________________________________
16
17DOUBLE                  DOUBLE PRECISION    REAL
18FLOAT                   REAL                REAL
19DECIMAL                 DECIMAL             REAL
20NUMERIC                 NUMERIC             REAL
21_______________________________________________________
22
23BOOLEAN                 BOOLEAN             INTEGER
24_______________________________________________________
25
26DATE                    DATE                TEXT
27TIME                    TIME
28DATETIME                TIMESTAMP
29_______________________________________________________
30
31TIMESTAMP DEFAULT       TIMESTAMP DEFAULT   TEXT
32NOW()                   NOW()   
33_______________________________________________________
34
35LONGTEXT                TEXT                TEXT
36MEDIUMTEXT              TEXT                TEXT
37BLOB                    BYTEA               BLOB
38VARCHAR                 VARCHAR             TEXT
39CHAR                    CHAR                TEXT
40_______________________________________________________
41
42columnname INT          columnname SERIAL   INTEGER PRIMARY 
43AUTO_INCREMENT                              KEY AUTOINCREMENT
source
similar questions
postgresql types and c 23 typespostgres float to intwhat is postgresqlpostgres time difference in minutespostgresql in vs any performanceaqua data studio postgresql ssldifference sql vs mysqlpostgresql get difference between two datesfloat postgresmysql vs postgresqlsql vs mysqlpostgresql difference between two dates in dayspostgres date difference secondspostgresql change column typepostgres switch between databasespostgresql get difference in hours between two datespostgres composite primary keysqlalchemy sequence postgresqlupdate column data type postgresdifference between left join and left outer join in postgresqlhow to check database in postgresql
queries leading to this page
mysql to postgresql data type mappingbigserial in mysqlmapping mysql to postgresql datatypesdifference mysql postgresmysql to postgresql mappingsql data types postgresbigserial mysqlmysql and postgresql are examples of popular datbasemysql vs postgresdata types postgresql vs mysqlpostgresql vs mysqlpostgres vs mysqlmysql data types vs postgresqlmysql vs postgresqlposgre vs mysqldata type postgresql vs mysqldifference between mysql and posgpostgresql mysql data type mapping bigintbig serial in mysqlmysql vs pgsqlpostgresql data typesdata types mysql vs postgresql