Class VenflowDbType

Inheritance

VenflowDbType

Namespace: Venflow

Assembly: Venflow.dll

Syntax

public static class VenflowDbType : object

Fields

| Improve this Doc View Source

Abstime

Corresponds to the obsolete PostgreSQL "abstime" type.

Declaration

public const int Abstime = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Array

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

Declaration

public const int Array = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Bigint

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

Declaration

public const int Bigint = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Bit

Corresponds to the PostgreSQL "bit" type.

Declaration

public const int Bit = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Boolean

Corresponds to the PostgreSQL "boolean" type.

Declaration

public const int Boolean = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Box

Corresponds to the PostgreSQL geometric "box" type.

Declaration

public const int Box = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Bytea

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

Declaration

public const int Bytea = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Char

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

Declaration

public const int Char = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Cid

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

Declaration

public const int Cid = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Cidr

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

Declaration

public const int Cidr = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Circle

Corresponds to the PostgreSQL geometric "circle" type.

Declaration

public const int Circle = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Citext

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

Declaration

public const int Citext = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Date

Corresponds to the PostgreSQL "date" type.

Declaration

public const int Date = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Double

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

Declaration

public const int Double = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Geography

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

Declaration

public const int Geography = null

Field Value

Type	Description
Int32

| Improve this Doc View Source

Geometry

The geometry type for PostgreSQL spatial extension PostGIS.

Declaration

public const int Geometry = null

Field Value

Type	Description
Int32

| Improve this Doc View Source

Hstore

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

Declaration

public const int Hstore = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Inet

Corresponds to the PostgreSQL "inet" type.

Declaration

public const int Inet = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Int2Vector

Corresponds to the PostgreSQL internal "int2vector" type.

Declaration

public const int Int2Vector = null

Field Value

Type	Description
Int32

| Improve this Doc View Source

Integer

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

Declaration

public const int Integer = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

InternalChar

Corresponds to the PostgreSQL "char" type.

Declaration

public const int InternalChar = null

Field Value

Type	Description
Int32

Remarks

This is an internal field and should normally not be used for regular applications.

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

| Improve this Doc View Source

Interval

Corresponds to the PostgreSQL "interval" type.

Declaration

public const int Interval = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Json

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

Declaration

public const int Json = null

Field Value

Type	Description
Int32

Remarks

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

Jsonb

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

Declaration

public const int Jsonb = null

Field Value

Type	Description
Int32

Remarks

Supported since PostgreSQL 9.4. See https://www.postgresql.org/docs/current/static/datatype-json.html

| Improve this Doc View Source

JsonPath

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

Declaration

public const int JsonPath = null

Field Value

Type	Description
Int32

Remarks

Supported since PostgreSQL 12. See https://www.postgresql.org/docs/current/datatype-json.html#DATATYPE-JSONPATH

| Improve this Doc View Source

Line

Corresponds to the PostgreSQL geometric "line" type.

Declaration

public const int Line = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

LQuery

The PostgreSQL lquery type for PostgreSQL extension ltree

Declaration

public const int LQuery = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

LSeg

Corresponds to the PostgreSQL geometric "lseg" type.

Declaration

public const int LSeg = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

LTree

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

Declaration

public const int LTree = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

LTxtQuery

The PostgreSQL ltxtquery type for PostgreSQL extension ltree

Declaration

public const int LTxtQuery = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

MacAddr

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

Declaration

public const int MacAddr = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

MacAddr8

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

Declaration

public const int MacAddr8 = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Money

Corresponds to the PostgreSQL "money" type.

Declaration

public const int Money = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Multirange

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

Declaration

public const int Multirange = null

Field Value

Type	Description
Int32

Remarks

Supported since PostgreSQL 14. See https://www.postgresql.org/docs/current/static/rangetypes.html

| Improve this Doc View Source

Name

Corresponds to the PostgreSQL internal "name" type.

Declaration

public const int Name = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Numeric

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

Declaration

public const int Numeric = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Oid

Corresponds to the PostgreSQL "oid" type.

Declaration

public const int Oid = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Oidvector

Corresponds to the PostgreSQL internal "oidvector" type.

Declaration

public const int Oidvector = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Path

Corresponds to the PostgreSQL geometric "path" type.

Declaration

public const int Path = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

PgLsn

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.

Declaration

public const int PgLsn = null

Field Value

Type	Description
Int32

Remarks

See: https://www.postgresql.org/docs/current/datatype-pg-lsn.html and https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=7d03a83f4d0736ba869fa6f93973f7623a27038a

| Improve this Doc View Source

Point

Corresponds to the PostgreSQL geometric "point" type.

Declaration

public const int Point = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Polygon

Corresponds to the PostgreSQL geometric "polygon" type.

Declaration

public const int Polygon = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Range

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

Declaration

public const int Range = null

Field Value

Type	Description
Int32

Remarks

Supported since PostgreSQL 9.2. See https://www.postgresql.org/docs/current/static/rangetypes.html

| Improve this Doc View Source

Real

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

Declaration

public const int Real = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Refcursor

Corresponds to the PostgreSQL "refcursor" type.

Declaration

public const int Refcursor = null

Field Value

Type	Description
Int32

| Improve this Doc View Source

Regconfig

Corresponds to the PostgreSQL "regconfig" type.

Declaration

public const int Regconfig = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Regtype

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

Declaration

public const int Regtype = null

Field Value

Type	Description
Int32

| Improve this Doc View Source

Smallint

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

Declaration

public const int Smallint = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Text

Corresponds to the PostgreSQL "text" type.

Declaration

public const int Text = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Tid

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

Declaration

public const int Tid = null

Field Value

Type	Description
Int32

| Improve this Doc View Source

Time

Corresponds to the PostgreSQL "time" type.

Declaration

public const int Time = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Timestamp

Corresponds to the PostgreSQL "timestamp" type.

Declaration

public const int Timestamp = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

TimestampTz

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

Declaration

public const int TimestampTz = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

TimestampTZ

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

Declaration

public const int TimestampTZ = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

TimeTz

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

Declaration

public const int TimeTz = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

TimeTZ

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

Declaration

public const int TimeTZ = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

TsQuery

Corresponds to the PostgreSQL "tsquery" type.

Declaration

public const int TsQuery = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

TsVector

Corresponds to the PostgreSQL "tsvector" type.

Declaration

public const int TsVector = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

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.

Declaration

public const int Unknown = null

Field Value

Type	Description
Int32

Remarks

This value shouldn't ordinarily be used, and makes sense only when sending a data type unsupported by Npgsql.

| Improve this Doc View Source

Uuid

Corresponds to the PostgreSQL "uuid" type.

Declaration

public const int Uuid = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Varbit

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

Declaration

public const int Varbit = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Varchar

Corresponds to the PostgreSQL "varchar" type.

Declaration

public const int Varchar = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Xid

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

Declaration

public const int Xid = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Xid8

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

Declaration

public const int Xid8 = null

Field Value

Type	Description
Int32

Remarks

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

| Improve this Doc View Source

Xml

Corresponds to the PostgreSQL "xml" type.

Declaration

public const int Xml = null

Field Value

Type	Description
Int32

Remarks

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