'Declaration Public Enum PgSqlType Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
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
public enum PgSqlType : System.Enum, 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
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2