与 Oracle 对照表(Oracle 兼容版特性)
Oracle | TDSQL PostgreSQL版(Oracle 兼容版) |
Number | 可以对应 TDSQL PostgreSQL版(Oracle 兼容版)的 smallint, integer, bigint, numeric(p,s) 等多种数据类型。由于 smallint,Integer,bigint 的算术运算效率比 numeric 高得多,所以要视业务需要转换成对应的 smallint, integer, bigint,无法转换时才转换成 numeric(p,s) |
float | float(实际按照 double precision 或 real 存储) |
binary_float | binary_float(实际按照 real 存储) |
binary_double | binary_double(实际按照 double precision 存储) |
char | char |
nchar | char |
varchar2 | varchar2 |
nvarchar2 | nvarchar2 |
rowid | rowid |
urowid | urowid |
long | long |
clob | clob |
nclob | nclob |
blob | blob |
bfile | bfile |
Long raw | Long raw |
raw | raw |
date | date |
timestamp | Timestamp |
Interval | interval |
与 MySQL 对照表
MySQL | TDSQL PostgreSQL版 |
int | int |
smallint | smallint |
bigint | bigint |
int AUTO_INCREMENT | serial |
smallint AUTO_INCREMENT | smallserial |
bigint AUTO_INCREMENT | bigserial |
bit | bit |
tinyint | smallint |
float | real |
double | double precision |
decimal | numeric |
char | char |
varchar | varchar |
text | text |
date | date |
time | time |
datetime | timestamp |
longblob | bytea |
Longtext | text |
ENUMCREATE 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); |
与 SQL Server 对照表
SQL Server | TDSQL PostgreSQL版 |
smallint | smallint |
int | int |
bigint | bigint |
tinyint | smallint |
real | real |
float | double precision |
numeric | numeric |
bit | bit |
char | char |
nchar | char |
varchar | varchar |
nvarchar | varchar |
text | text |
ntext | text |
date | date |
time | time |
datetime | timestamp |
datetime2 | timestamp |
smalldatetime | timestamp |
datetimeoffset | Timestamp |
timestamp | money |
uniqueidentifier | uuid |
image | bytea |
binary | bytea |
varbinary | bytea |
与 informix 对照表
informix | TDSQL PostgreSQL版 |
smallint | smallint |
integer | integer |
float | double precision |
smallfloat | double precision |
DECIMAL | numeric |
MONEY | numeric |
char | char |
varchar | varchar |
lvarchar | varchar |
text | text |
date | date |
datetime | timestamp |
interval | interval |
BYTE | bytea |