Search Results for

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

    Date

    Corresponds to the PostgreSQL "date" type.

    Double

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

    Geography

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

    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.

    MacAddr8

    Corresponds to the PostgreSQL "macaddr8" type, a field storing a 6-byte or 8-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 "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

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

    Refcursor

    Corresponds to the PostgreSQL "refcursor" type.

    Regconfig

    Corresponds to the PostgreSQL "tsquery" 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.

    TimestampTZ

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

    TimeTz

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

    • Improve this Doc
    In This Article
    Back to top © Copyright 2021 The Npgsql Development Team