Enumeration

PgsqlValueType

Declaration

enum Pgsql.ValueType

Description

PostgreSQL parameter and field types.

Members

PGSQL_VALUE_TYPE_INVALID

Invalid or unknown type.

  • Value: 0
  • Available since: 1
PGSQL_VALUE_TYPE_BOOL

Boolean type.

  • Value: 1
  • Available since: 1
PGSQL_VALUE_TYPE_INT2

16-bit integer (SMALLINT).

  • Value: 2
  • Available since: 1
PGSQL_VALUE_TYPE_INT4

32-bit integer (INTEGER).

  • Value: 3
  • Available since: 1
PGSQL_VALUE_TYPE_INT8

64-bit integer (BIGINT).

  • Value: 4
  • Available since: 1
PGSQL_VALUE_TYPE_TEXT

Text type.

  • Value: 5
  • Available since: 1
PGSQL_VALUE_TYPE_VARCHAR

Variable-length character string.

  • Value: 6
  • Available since: 1
PGSQL_VALUE_TYPE_FLOAT4

32-bit floating point (REAL).

  • Value: 7
  • Available since: 1
PGSQL_VALUE_TYPE_FLOAT8

64-bit floating point (DOUBLE PRECISION).

  • Value: 8
  • Available since: 1
PGSQL_VALUE_TYPE_NUMERIC

Arbitrary precision numeric type.

  • Value: 9
  • Available since: 1
PGSQL_VALUE_TYPE_DATE

Date type.

  • Value: 10
  • Available since: 1
PGSQL_VALUE_TYPE_TIME

Time type.

  • Value: 11
  • Available since: 1
PGSQL_VALUE_TYPE_TIMESTAMP

Timestamp without time zone.

  • Value: 12
  • Available since: 1
PGSQL_VALUE_TYPE_TIMESTAMPTZ

Timestamp with time zone.

  • Value: 13
  • Available since: 1
PGSQL_VALUE_TYPE_BYTEA

Binary data type.

  • Value: 14
  • Available since: 1
PGSQL_VALUE_TYPE_UUID

Universally unique identifier.

  • Value: 15
  • Available since: 1
PGSQL_VALUE_TYPE_JSON

JSON data type.

  • Value: 16
  • Available since: 1
PGSQL_VALUE_TYPE_JSONB

Binary JSON data type.

  • Value: 17
  • Available since: 1