PostgresColumnType

Topics

Instance Methods

• serialize(to:)
  Invoked when a request is made to serialize the expression to raw SQL.

Type Properties

• bigint
  signed eight-byte integer
• bigserial
  autoincrementing eight-byte integer
• bit
  fixed-length bit string
• blob
• bool
  logical Boolean (true/false)
• boolean
  logical Boolean (true/false)
• box
  rectangular box on a plane
• bytea
  binary data (“byte array”)
• char
  fixed-length character string
• cidr
  IPv4 or IPv6 network address
• circle
  circle on a plane
• date
  calendar date (year, month, day)
• decimal
  exact numeric of selectable precision
• doublePrecision
  floating-point number (8 bytes)
• float4
  single precision floating-point number (4 bytes)
• float8
  floating-point number (8 bytes)
• inet
  IPv4 or IPv6 host address
• int
  signed four-byte integer
• int2
  signed two-byte integer
• int4
  signed four-byte integer
• int8
  signed eight-byte integer
• integer
  signed four-byte integer
• interval
  time span
• 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
  exact numeric of selectable precision
• path
  geometric path on a plane
• pgLSN
  PostgreSQL Log Sequence Number
• point
  geometric point on a plane
• polygon
  closed geometric path on a plane
• real
  single precision floating-point number (4 bytes)
• serial
  autoincrementing four-byte integer
• serial2
  autoincrementing two-byte integer
• serial4
  autoincrementing four-byte integer
• serial8
  autoincrementing eight-byte integer
• smallint
  signed two-byte integer
• smallserial
  autoincrementing two-byte integer
• text
  variable-length character string
• time
  time of day (no time zone)
• timestamp
  date and time (no time zone)
• timestamptz
  date and time, including time zone
• timetz
  time of day, including time zone
• tsquery
  text search query
• tsvector
  text search document
• txidSnapshot
  user-level transaction ID snapshot
• uuid
  universally unique identifier
• varbit
  variable-length bit string
• varchar
  variable-length character string
• xml
  XML data

Type Methods

• array(_:)
  Creates an array type from a PostgreSQLDataType.
• bit(_:)
  fixed-length bit string
• char(_:)
  fixed-length character string
• custom(_:)
  User-defined type
• decimal(_:_:)
  exact numeric of selectable precision
• numeric(_:_:)
  exact numeric of selectable precision
• time(_:)
  time of day (no time zone)
• timestamp(_:)
  date and time (no time zone)
• timestamptz(_:)
  date and time, including time zone
• timetz(_:)
  time of day, including time zone
• varbit(_:)
  variable-length bit string
• varchar(_:)
  variable-length character string