PostgreSQL Datatypes

AttentionThis page documents an earlier version. Go to the latest (v2.1)version.

The following table lists all supported primitive types.

Primitive TypeAllowed in KeyType ParametersDescription
BIGINTYes-64-bit signed integer
BOOLEANYes-Boolean
DECIMALYes-Exact, fixed-point number
DOUBLE PRECISIONYes-64-bit, inexact, floating-point number
FLOATYes-64-bit, inexact, floating-point number
REALYes-32-bit, inexact, floating-point number
INT | INTEGERYes-32-bit signed integer
SMALLINTYes-16-bit signed integer
TEXT | VARCHARYes-Variable-size string of Unicode characters