与MYSQL数据类型对照表
最近更新时间: 2025-02-18 16:02:00
| Mysql | TDSQL PG |
|---|---|
| int | int |
| smallint | smallint |
| bigint | bigint |
| int AUTO_INCREMENT | serial |
| smallint AUTO_INCREMENT | smallserial |
| bigint AUTO_INCREMENT | bigserial |
| bit | bit |
| tinyint | boolean |
| float | real |
| double | double precision |
| decimal | numeric |
| char | char |
| varchar | varchar |
| text | text |
| date | date |
| time | time |
| datetime | timestamp |
| longblob | bytea |
| Longtext | text |
| ENUM CREATE TABLE TYPE022(COL1 ENUM('S','M','L','XL','XXL','XXXL') ,COL2 INT PRIMARY KEY); | 自定义类型 CREATE TYPE mood AS ENUM ('S','M','L','XL','XXL','XXXL'); CREATE TABLE TYPE022(COL1 mood ,COL2 INT PRIMARY KEY) |
| SET类型 CREATE TABLE TYPE023(COL1 SET('A','B', 'C','D') ,COL2 INT PRIMARY KEY) | CREATE TABLE TYPE023(COL1 VARCHAR check(regexp_split_to_array(col1,',') <@ array['A','B','C','D']) ,COL2 INT PRIMARY KEY); |