SQL Data Types

Type Use Size (bytes) Syntax
boolean State of TRUE or FALSE 1 TRUE, FALSE
date Date without a specified time 4 DATE '2007-02-01'
decimal Signed exact number with user-defined precision and scale 16 1.23
float Signed variable-precision, inexact number 8 1.23
int Signed integer 8 123
interval Duration of time 32 INTERVAL '1-2 3 4:5:6.7'
jsonb JSON Variable '{"1":2,"3":4}'::JSONB
string Unicode string Variable 'foo'
timestamp Date and time 8 TIMESTAMP '2007-02-01 15:04:05'
timestamptz Date and time with timezone 8 TIMESTAMPTZ '2007-02-01 15:04:05+06'