Skip to content

Postgres support (data types) #46

@nene

Description

@nene

Builtin data types

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

Range types

Object identifier types

Array types

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

User-defined types

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions