More Data Types

I l @ ve RuBoard

The following is a listing of some of the more obscure PostgreSQL data types (some of these types are only aliases to previously documented types):

abstime ”Holds an absolute system (UNIX) time.

aclitem ”Holds an access control list item.

bpchar ”Holds a blank- padded fixed-length string.

bytea ”Holds a variable-length binary value.

cid ”Holds a command identifier type and is used in transactions.

filename ”Holds a filename and is used in system tables.

int2vectory ”Holds an array of 16 INT2 type values.

lztext ”Holds variable-length text and is stored compressed.

oidvector ”Holds an array of 16 OIDs and is used in system tables.

regproc ”Holds registered procedures.

reltime ”Holds relative time (UNIX delta).

timetz ”Holds an ANSI SQL time (hh:mm:ss).

tinterval ”Holds an array of (abstime, abstime).

varbit ”Holds a fixed-length bit value.

xid ”Holds a transaction ID sequence.

I l @ ve RuBoard