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)

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.

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.

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.

Jsonb = 36

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

LSeg = 11

Corresponds to the PostgreSQL geometric "lseg" type.

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.

Name = 32

Corresponds to the PostgreSQL internal "name" type.

Numeric = 13

Corresponds to the PostgreSQL arbitrary-precision "numeric" 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.

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 "tsquery" 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.

[Obsolete("Use TimeTz instead")] TimeTZ = 31

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

TimeTz = 31

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

Timestamp = 21

Corresponds to the PostgreSQL "timestamp" type.

[Obsolete("Use TimestampTz instead")] TimestampTZ = 26

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

TimestampTz = 26

Corresponds to the PostgreSQL "timestamp with time zone" 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.

Xml = 28

Corresponds to the PostgreSQL "xml" type.

Remarks

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