Skip to main content

Type Alias: SqlType

SqlType: "boolean" | "integer" | "text" | `varchar(${Number})` | "numeric" | `numeric(${Number}, ${Number})` | "json" | "uuid" | `binary(${Number})` | "timestamp" | "timestamp with time zone"

Represents a SQL data type.

A string that represents a SQL data type. It can have the following values:

  • boolean: Represents a boolean data type.
  • integer: Represents an integer data type.
  • text: Represents a text data type.
  • varchar(${number}): Represents a variable-length character string data type with a specified maximum length.
  • numeric: Represents a numeric data type.
  • numeric(${number}, ${number}): Represents a numeric data type with a specified precision and scale.
  • json: Represents a JSON data type.
  • uuid: Represents a UUID data type.
  • binary(${number}): Represents a binary data type with a specified maximum length.
  • timestamp: Represents a timestamp data type.
  • timestamp with time zone: Represents a timestamp data type with time zone information.

Defined in

packages/verse-core/src/db/sql.ts:729