Enum NpgsqlDbType

Namespace

NpgsqlTypes

Assembly

Npgsql.dll

Represents a PostgreSQL data type that can be written or read to the database. Used in places such as NpgsqlDbType to unambiguously specify how to encode or decode values.

public enum NpgsqlDbType

Fields

[Obsolete("The PostgreSQL abstime time is obsolete.")] Abstime = 33

Corresponds to the obsolete PostgreSQL "abstime" type.

Array = -2147483648

Corresponds to the PostgreSQL "array" type, a variable-length multidimensional array of another type. This value must be combined with another value from NpgsqlDbType via a bit OR (e.g. NpgsqlDbType.Array | NpgsqlDbType.Integer)

BigIntMultirange = 536870913

Corresponds to the PostgreSQL "int8multirange" type.

BigIntRange = 1073741825

Corresponds to the PostgreSQL "int8range" type.

Bigint = 1

Corresponds to the PostgreSQL 8-byte "bigint" type.

Bit = 25

Corresponds to the PostgreSQL "bit" type.

Boolean = 2

Corresponds to the PostgreSQL "boolean" type.

Box = 3

Corresponds to the PostgreSQL geometric "box" type.

Bytea = 4

Corresponds to the PostgreSQL "bytea" type, holding a raw byte string.

Char = 6

Corresponds to the PostgreSQL "char(n)" type.

Cid = 43

Corresponds to the PostgreSQL "cid" type, an internal command identifier.

Cidr = 44

Corresponds to the PostgreSQL "cidr" type, a field storing an IPv4 or IPv6 network.

Circle = 5

Corresponds to the PostgreSQL geometric "circle" type.

Citext = 51

Corresponds to the PostgreSQL "citext" type for the citext module.

Date = 7

Corresponds to the PostgreSQL "date" type.

DateMultirange = 536870919

Corresponds to the PostgreSQL "datemultirange" type.

DateRange = 1073741831

Corresponds to the PostgreSQL "daterange" type.

Double = 8

Corresponds to the PostgreSQL 8-byte floating-point "double" type.

Geography = 55

The geography (geodetic) type for PostgreSQL spatial extension PostGIS.

Geometry = 50

The geometry type for PostgreSQL spatial extension PostGIS.

Hstore = 37

Corresponds to the PostgreSQL "hstore" type, a dictionary of string key-value pairs.

Inet = 24

Corresponds to the PostgreSQL "inet" type.

Int2Vector = 52

Corresponds to the PostgreSQL internal "int2vector" type.

Integer = 9

Corresponds to the PostgreSQL 4-byte "integer" type.

IntegerMultirange = 536870921

Corresponds to the PostgreSQL "int4multirange" type.

IntegerRange = 1073741833

Corresponds to the PostgreSQL "int4range" type.

InternalChar = 38

Corresponds to the PostgreSQL "char" type.

Interval = 30

Corresponds to the PostgreSQL "interval" type.

Json = 35

Corresponds to the PostgreSQL "json" type, a field storing JSON in text format.

JsonPath = 57

Corresponds to the PostgreSQL "jsonpath" type, a field storing JSON path in text format. format.

Jsonb = 36

Corresponds to the PostgreSQL "jsonb" type, a field storing JSON in an optimized binary. format.

LQuery = 61

The PostgreSQL lquery type for PostgreSQL extension ltree

LSeg = 11

Corresponds to the PostgreSQL geometric "lseg" type.

LTree = 60

The PostgreSQL ltree type, each value is a label path "a.label.tree.value", forming a tree in a set.

LTxtQuery = 62

The PostgreSQL ltxtquery type for PostgreSQL extension ltree

Line = 10

Corresponds to the PostgreSQL geometric "line" type.

MacAddr = 34

Corresponds to the PostgreSQL "macaddr" type, a field storing a 6-byte physical address.

MacAddr8 = 54

Corresponds to the PostgreSQL "macaddr8" type, a field storing a 6-byte or 8-byte physical address.

Money = 12

Corresponds to the PostgreSQL "money" type.

Multirange = 536870912

Corresponds to the PostgreSQL "multirange" type, continuous range of values of specific type. This value must be combined with another value from NpgsqlDbType via a bit OR (e.g. NpgsqlDbType.Multirange | NpgsqlDbType.Integer)

Name = 32

Corresponds to the PostgreSQL internal "name" type.

Numeric = 13

Corresponds to the PostgreSQL arbitrary-precision "numeric" type.

NumericMultirange = 536870925

Corresponds to the PostgreSQL "nummultirange" type.

NumericRange = 1073741837

Corresponds to the PostgreSQL "numrange" type.

Oid = 41

Corresponds to the PostgreSQL "oid" type.

Oidvector = 29

Corresponds to the PostgreSQL internal "oidvector" type.

Path = 14

Corresponds to the PostgreSQL geometric "path" type.

PgLsn = 59

Corresponds to the PostgreSQL "pg_lsn" type, which can be used to store LSN (Log Sequence Number) data which is a pointer to a location in the WAL.

Point = 15

Corresponds to the PostgreSQL geometric "point" type.

Polygon = 16

Corresponds to the PostgreSQL geometric "polygon" type.

Range = 1073741824

Corresponds to the PostgreSQL "range" type, continuous range of values of specific type. This value must be combined with another value from NpgsqlDbType via a bit OR (e.g. NpgsqlDbType.Range | NpgsqlDbType.Integer)

Real = 17

Corresponds to the PostgreSQL floating-point "real" type.

Refcursor = 23

Corresponds to the PostgreSQL "refcursor" type.

Regconfig = 56

Corresponds to the PostgreSQL "regconfig" type.

Regtype = 49

Corresponds to the PostgreSQL "regtype" type, a numeric (OID) ID of a type in the pg_type table.

Smallint = 18

Corresponds to the PostgreSQL 2-byte "smallint" type.

Text = 19

Corresponds to the PostgreSQL "text" type.

Tid = 53

Corresponds to the PostgreSQL "tid" type, a tuple id identifying the physical location of a row within its table.

Time = 20

Corresponds to the PostgreSQL "time" type.

TimeTz = 31

Corresponds to the PostgreSQL "time with time zone" type.

Timestamp = 21

Corresponds to the PostgreSQL "timestamp" type.

TimestampMultirange = 536870933

Corresponds to the PostgreSQL "tsmultirange" type.

TimestampRange = 1073741845

Corresponds to the PostgreSQL "tsrange" type.

TimestampTz = 26

Corresponds to the PostgreSQL "timestamp with time zone" type.

TimestampTzMultirange = 536870938

Corresponds to the PostgreSQL "tstzmultirange" type.

TimestampTzRange = 1073741850

Corresponds to the PostgreSQL "tstzrange" type.

TsQuery = 46

Corresponds to the PostgreSQL "tsquery" type.

TsVector = 45

Corresponds to the PostgreSQL "tsvector" type.

Unknown = 40

A special value that can be used to send parameter values to the database without specifying their type, allowing the database to cast them to another value based on context. The value will be converted to a string and send as text.

Uuid = 27

Corresponds to the PostgreSQL "uuid" type.

Varbit = 39

Corresponds to the PostgreSQL "varbit" type, a field storing a variable-length string of bits.

Varchar = 22

Corresponds to the PostgreSQL "varchar" type.

Xid = 42

Corresponds to the PostgreSQL "xid" type, an internal transaction identifier.

Xid8 = 64

Corresponds to the PostgreSQL "xid8" type, an internal transaction identifier.

Xml = 28

Corresponds to the PostgreSQL "xml" type.

Remarks

See https://www.postgresql.org/docs/current/static/datatype.html.