A variety of data types can be used with Fujitsu Enterprise Postgres.
List of supported data types
Data Type |
|---|
boolean |
smallint |
integer |
bigint |
real |
double precision |
numeric |
money |
text |
character varying |
character |
national character varying |
national character |
citext |
json |
jsonb |
xml |
uuid |
bytea |
timestamp without time zone |
timestamp with time zone |
date |
time without time zone(*1) |
time with time zone(*1) |
interval(*2) |
cidr |
inet |
macaddr |
tsquery |
tsvector |
bit(1) |
bit(n) |
bit varying |
point |
lseg |
path |
polygon |
line |
circle |
box |
hstore |
oid |
xid |
cid |
oidvector |
name |
(internal) char |
geometry (PostGIS) |
record |
composite types |
range types |
multirange types (PG14) |
enum types |
array types |
*1: As shown below, "time with time zone" and "time without time zone" values display the date portion as additional information. However, the actual data comprises the time data only, so with the exception of this displayed format, there are no other resulting issues.
Example:
Composition of table (t1)
col1 (time with time zone) | col2 (time without time zone) |
|---|---|
1/01/0001 10:21:30 +08:00 | 10:21:30 |
1/01/0001 23:34:03 +08:00 | 23:34:03 |
1/01/0001 17:23:54 +08:00 | 17:23:54 |
"time with time zone" values display a fixed value of “2/01/0001” in the date portion, while "time without time zone" values display just the time data.
SELECT * FROM t1; col1 | col2 ----------------------------+--------------------- 1/01/0001 10:21:30 +08:00 | 10:21:30 1/01/0001 23:34:03 +08:00 | 23:34:03 1/01/0001 17:23:54 +08:00 | 17:23:54
*2: The format is d.hh:mm:ss, where d is an integer and hh:mm:ss is a maximum of 23.59.59 (23 hours, 59 minutes, and 59 seconds).
