Postgres support (data types)

[nene]

Builtin data types

• [x] bigint, int8 - signed eight-byte integer
• [x] bigserial, serial8 autoincrementing eight-byte integer
• [x] bit [ (n) ] fixed-length bit string
• [x] bit varying [ (n) ], varbit [ (n) ] variable-length bit string
• [x] boolean, bool logical Boolean (true/false)
• [x] box rectangular box on a plane
• [x] bytea binary data (“byte array”)
• [x] character [ (n) ], char [ (n) ] fixed-length character string
• [x] character varying [ (n) ], varchar [ (n) ] variable-length character string
• [x] cidr IPv4 or IPv6 network address
• [x] circle circle on a plane
• [x] date calendar date (year, month, day)
• [x] double precision, float8 double precision floating-point number (8 bytes)
• [x] inet IPv4 or IPv6 host address
• [x] integer, int, int4 signed four-byte integer
• [x] interval time span
  • [x] interval [ (p) ]
  • [x] interval [ fields ] [ (p) ] like interval year to month or interval seconds (50)
• [x] json textual JSON data
• [x] jsonb binary JSON data, decomposed
• [x] line infinite line on a plane
• [x] lseg line segment on a plane
• [x] macaddr MAC (Media Access Control) address
• [x] macaddr8 MAC (Media Access Control) address (EUI-64 format)
• [x] money currency amount
• [x] numeric [ (p, s) ], decimal [ (p, s) ] exact numeric of selectable precision
• [x] dec [ (p, s) ] (not documented???)
• [x] path geometric path on a plane
• [x] pg_lsn PostgreSQL Log Sequence Number
• [x] pg_snapshot user-level transaction ID snapshot
• [x] point geometric point on a plane
• [x] polygon closed geometric path on a plane
• [x] real, float4 single precision floating-point number (4 bytes)
• [x] smallint, int2 signed two-byte integer
• [x] smallserial, serial2 autoincrementing two-byte integer
• [x] serial, serial4 autoincrementing four-byte integer
• [x] text variable-length character string
• [x] time time of day
  • [x] time [ (p) ]
  • [x] timetz [ (p) ]
  • [x] time without time zone
  • [x] time with time zone
  • [x] time (p) without time zone
  • [x] time (p) with time zone
• [x] timestamp date and time
  • [x] timestamp [ (p) ]
  • [x] timestamptz [ (p) ]
  • [x] timestamp without time zone
  • [x] timestamp with time zone
  • [x] timestamp (p) without time zone
  • [x] timestamp (p) with time zone
• [x] tsquery text search query
• [x] tsvector text search document
• [x] txid_snapshot user-level transaction ID snapshot (deprecated; see pg_snapshot)
• [x] uuid universally unique identifier
• [x] xml XML data

Range types

• [x] range types

Object identifier types

• [x] Object identifier types

Array types

• [x] int[], int[][], int[10][10][10]

User-defined types

• [x] User-defined types
• See also the enum type
• See also domain types