Blog Post by Murat Yaşar

Posted on Monday, September 27, 2010 8:21:32 PM and it has been read 1825 times since then.

PostgreSQL 8.4.4 Data Types

Name Aliases Description
bigint int8 signed eight-byte integer
bigserial serial8 autoincrementing eight-byte integer
bit [ (n) ]   fixed-length bit string
boolean bool logical Boolean (true/false)
box   rectangular box on a plane
bytea   binary data ("byte array")
cidr   IPv4 or IPv6 network address
circle   circle on a plane
date   calendar date (year, month, day)
inet   IPv4 or IPv6 host address
integer int, int4 signed four-byte integer
interval [ fields ] [ (p) ]   time span
line   infinite line on a plane
lseg   line segment on a plane
macaddr   MAC (Media Access Control) address
money   currency amount
path   geometric path on a plane
point   geometric point on a plane
polygon   closed geometric path on a plane
real float4 single precision floating-point number (4 bytes)
smallint int2 signed two-byte integer
serial serial4 autoincrementing four-byte integer
text   variable-length character string
tsquery   text search query
tsvector   text search document
txid_snapshot   user-level transaction ID snapshot
uuid   universally unique identifier
xml   XML data

This table of information has been taken from PostgreSQL 8.4.4 Documentation - Data Types
