Appendix E. Data Types in pgpro_metastore

boolean

true or false.

int8

Integer, from -128 to 127.

int16

Integer, from -32768 to 32767.

int32

Integer, from -2 147 483 648 to 2 147 483 647.

int64

Integer, from -9 223 372 036 854 775 808 to 9 223 372 036 854 775 807.

unit8

Integer, from 0 to 255.

unit16

Integer, from 0 to 65535.

unit32

Integer, from 0 to 4 294 967 295.

unit64

Integer, from 0 to 18 446 744 073 709 551 615.

float32

Fraction, approximately from 1.17549435E-38 to 3.40282347E+38.

Precision: 6–7 numbers after the comma.

float64

Float, approximately from 4.9E-324 to 1.8E+308.

Precision: 14–15 numbers after the comma.

decimal

Decimal, for example, decimal(5,2) is 123.45 or 999.99.

time

Time, for example, 13:00:00.

timez

Time with timezone, for example, 10:30:00+03.

date

Date, for example, 2023-05-13.

timestamp

Timestamp, for example, 2023-05-15 14:30:00.

timestamptz

Timestamp with timezone, for example, 2023-05-15 14:30:00+03.

timestamp_s

Second-precision timestamp, for example, 2023-05-15 14:30:00+03.

timestamp_ms

Millisecond-precison timestamp, for example, 2023-05-15 14:30:00.123.

timestamp_ns

Nanosecond-precision timestamp, for example, 2023-05-15 14:30:00.123456789.

interval

Time interval, for example, 1 day, 1 hour, 1 minute.

varchar

Varchar, for example, abcde, 12&^gh.

blob

Blob, for example, PDF, image, video, audio.

json

JSON, for example, {"brand": "Apple","model": "MacBook Pro","screen_size": 13.3,"ram": "16GB"}.

json

UUID, for example, a81bc81b-dead-4e5d-abff-90865d1e13b1.