public enum PgSqlType : System.Enum, System.IComparable, System.IConvertible, System.IFormattable
'Declaration Public Enum PgSqlType Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
Member | Description |
---|---|
Array | A PostgreSQL array data type. May be represented as the PgSqlArray class or the System.String. |
BigInt | A PostgreSQL bigint data type that contains a 64-bit signed integer. Represented as the System.Int64. |
BigIntMultirange | A PostgreSQL int8multirange type. Represented as an array of PgSqlBigIntRange. |
BigIntRange | A PostgreSQL int8range type. Represented as the PgSqlBigIntRange. |
Bit | A PostgreSQL bit data type that contains a fixed-length bit string. Represented as the System.BitArray. |
Boolean | A simple type representing Boolean values of true or false. |
Box | A PostgreSQL box geometric data type that represents rectangular box in the plane. May be represented as the PgSqlBox class or the System.String. |
ByteA | A PostgreSQL bytea data type that contains a variable-length stream of binary data. May be represented as the PgSqlBlob class or the array of System.Byte. |
Char | A PostgreSQL char data type that contains a fixed-length character string. Represented as the System.String. |
CIdr | A PostgreSQL cidr data type that contains a an IPv4 or IPv6 network specification. May be represented as the PgSqlInet class. |
Circle | A PostgreSQL circle geometric data type that represents circle in the plane. May be represented as the PgSqlCircle class or the System.String. |
Date | A PostgreSQL date data type that contains a fixed-length representation of a date value. Represented as the System.DateTime. |
DateMultirange | A PostgreSQL datemultirange type. Represented as an array of PgSqlDateRange. |
DateRange | A PostgreSQL daterange type. Represented as the PgSqlDateRange. |
Double | A PostgreSQL double data type that contains a double-precision floating-point value. A floating point type representing values ranging from approximately 5.0 x 10(-324) to 1.7 x 10(308) with a precision of 15-16 digits. Represented as the System.Double. |
Inet | A PostgreSQL inet data type that contains an IPv4 or IPv6 address and optionally its subnet. May be represented as the PgSqlInet class. |
Int | A PostgreSQL integer data type that contains a 32-bit signed integer. Represented as the System.Int32. |
Interval | A PostgreSQL interval data type that contains an interval of time in days, hours, minutes, and seconds. Represented as the PgSqlInterval. |
IntMultirange | A PostgreSQL int4multirange type. Represented as an array of PgSqlIntRange. |
IntRange | A PostgreSQL int4range type. Represented as the PgSqlIntRange. |
Json | A PostgreSQL json data type that contains a JSON object. Represented as the System.String. |
JsonB | A PostgreSQL jsonb data type that contains a JSON object in a decomposed binary format. Represented as the System.String. |
LargeObject | A PostgreSQL large object. May be represented as the PgSqlLargeObject class or the System.String. |
Line | A PostgreSQL line geometric data type that represents infinite line in the plane. May be represented as the PgSqlLSeg class or the System.String. |
LSeg | A PostgreSQL lseg geometric data type that represents line segment in the plane. May be represented as the PgSqlLSeg class or the System.String. |
MacAddr | A PostgreSQL macaddr data type that contains a MAC address. May be represented as the PgSqlMacAddr class. |
MacAddr8 | A PostgreSQL macaddr data type that contains a MAC address in 8 byte length EUI-64 format. May be represented as the PgSqlMacAddr class. |
Money | A PostgreSQL money data type that contains a currency amount with a fixed fractional precision. |
Numeric | A PostgreSQL numeric data type that contains exact numeric data with selectable precision. Represented as the System.Decimal. |
NumericMultirange | A PostgreSQL nummultirange type. Represented as an array of PgSqlNumericRange. |
NumericRange | A PostgreSQL numrange type. Represented as the PgSqlNumericRange. |
Path | A PostgreSQL path geometric data type that represents open and closed geometric path in the plane. May be represented as the PgSqlPath class or the System.String. |
Point | A PostgreSQL point geometric data type that represents geometric point in the plane. May be represented as the PgSqlPoint class or the System.String. |
Polygon | A PostgreSQL polygon geometric data type that represents closed geometric path in the plane. May be represented as the PgSqlPolygon class or the System.String. |
Real | A PostgreSQL real data type that contains a single-precision floating-point value. Represented as the System.Single. |
Row | A PostgreSQL row data type that contains composite value. This type does not have corresponding .NET Framework type. |
SmallInt | A PostgreSQL smallint data type that contains a 16-bit signed integer. Represented as the System.Int16. |
Text | A PostgreSQL text data type that contains a variable-length character string. May be represented as the PgSqlText class or the System.String. |
Time | A PostgreSQL time data type that contains a fixed-length representation of a time value. Represented as the System.TimeSpan. |
TimeStamp | A PostgreSQL timestamp data type that contains date and time, including seconds. Represented as the System.DateTime. |
TimeStampMultirange | Represents the PostgreSQL tsmultirange type. Represented as an array of PgSqlTimeStampRange. |
TimeStampRange | Represents the PostgreSQL tsrange type. Represented as PgSqlTimeStampRange. |
TimeStampTZ | A PostgreSQL timestamp with time zone data type that contains date and time, including seconds, with time zone. Represented as the System.DateTime. |
TimeStampTZMultirange | Represents the PostgreSQL tstzmultirange type. Represented as an array of PgSqlTimeStampTZRange. |
TimeStampTZRange | Represents the PostgreSQL tstzrange type. Represented as PgSqlTimeStampTZRange. |
TimeTZ | A PostgreSQL time with time zone data type that contains a fixed-length representation of a time value with time zone. Represented as the System.TimeSpan. |
Uuid | A PostgreSQL UUID data type that represents a unique value. Represented as the System.Guid. |
VarBit | A PostgreSQL varbit data type that contains a variable-length bit string. Represented as the System.BitArray. |
VarChar | A PostgreSQL varchar data type that contains a variable-length character string. Represented as the System.String. |
Xml | A PostgreSQL xml type that contains XML data. May be represented as the System.String object. |
System.Object
System.ValueType
System.Enum
Devart.Data.PostgreSql.PgSqlType