YQL |
PostgreSQL |
Название PostgreSQL-типа в YQL |
Bool |
bool |
pgbool |
Int8 |
int2 |
pgint2 |
Uint8 |
int2 |
pgint2 |
Int16 |
int2 |
pgint2 |
Uint16 |
int4 |
pgint4 |
Int32 |
int4 |
pgint4 |
Uint32 |
int8 |
pgint8 |
Int64 |
int8 |
pgint8 |
Uint64 |
numeric |
pgnumeric |
Float |
float4 |
pgfloat4 |
Double |
float8 |
pgfloat8 |
String |
bytea |
pgbytea |
Utf8 |
text |
pgtext |
Yson |
bytea |
pgbytea |
Json |
json |
pgjson |
Uuid |
uuid |
pguuid |
JsonDocument |
jsonb |
pgjsonb |
Date |
date |
pgdate |
Datetime |
timestamp |
pgtimestamp |
Timestamp |
timestamp |
pgtimestamp |
Interval |
interval |
pginterval |
TzDate |
text |
pgtext |
TzDatetime |
text |
pgtext |
TzTimestamp |
text |
pgtext |
Date32 |
date |
pgdate |
Datetime64 |
timestamp |
pgtimestamp |
Timestamp64 |
timestamp |
pgtimestamp |
Interval64 |
interval |
pginterval |
TzDate32 |
text |
|
TzDatetime64 |
text |
|
TzTimestamp64 |
text |
|
Decimal |
numeric |
pgnumeric |
DyNumber |
numeric |
pgnumeric |