Show / Hide Table of Contents

Enum NpgsqlDbType

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.

Namespace: NpgsqlTypes
Assembly: Npgsql.dll
Syntax
public enum NpgsqlDbType : int
Remarks

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

Fields

Name Description
Abstime

Corresponds to the obsolete PostgreSQL "abstime" type.

Array

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

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

Bit

Corresponds to the PostgreSQL "bit" type.

Boolean

Corresponds to the PostgreSQL "boolean" type.

Box

Corresponds to the PostgreSQL geometric "box" type.

Bytea

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

Char

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

Cid

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

Cidr

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

Circle

Corresponds to the PostgreSQL geometric "circle" type.

Citext

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

Composite

Corresponds to the PostgreSQL "composite" type.

Date

Corresponds to the PostgreSQL "date" type.

Double

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

Enum

Corresponds to the PostgreSQL "enum" type.

Geometry

The geometry type for postgresql spatial extension postgis.

Hstore

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

Inet

Corresponds to the PostgreSQL "inet" type.

Int2Vector

Corresponds to the PostgreSQL internal "int2vector" type.

Integer

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

InternalChar

Corresponds to the PostgreSQL "char" type.

Interval

Corresponds to the PostgreSQL "interval" type.

Json

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

Jsonb

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

Line

Corresponds to the PostgreSQL geometric "line" type.

LSeg

Corresponds to the PostgreSQL geometric "lseg" type.

MacAddr

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

Money

Corresponds to the PostgreSQL "money" type.

Name

Corresponds to the PostgreSQL internal "name" type.

NChar

Corresponds to the PostgreSQL "NChar" type.

Numeric

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

NVarchar

Corresponds to the PostgreSQL "NVarchar" type.

Oid

Corresponds to the PostgreSQL "oid" type.

Oidvector

Corresponds to the PostgreSQL internal "oidvector" type.

Path

Corresponds to the PostgreSQL geometric "path" type.

Point

Corresponds to the PostgreSQL geometric "point" type.

Polygon

Corresponds to the PostgreSQL geometric "polygon" type.

Range

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)

Real

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

Refcursor

Corresponds to the PostgreSQL "refcursor" type.

Regtype

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

Smallint

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

Text

Corresponds to the PostgreSQL "text" type.

Tid

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

Time

Corresponds to the PostgreSQL "time" type.

Timestamp

Corresponds to the PostgreSQL "timestamp" type.

TimestampTZ

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

TimeTZ

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

TsQuery

Corresponds to the PostgreSQL "tsquery" type.

TsVector

Corresponds to the PostgreSQL "tsvector" type.

Unknown

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

Corresponds to the PostgreSQL "uuid" type.

Varbit

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

Varchar

Corresponds to the PostgreSQL "varchar" type.

Xid

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

Xml

Corresponds to the PostgreSQL "xml" type.

Back to top Copyright © 2015-2017 Microsoft
Generated by DocFX