Posted on Monday, March 21, 2011 9:37:59 AM and it has been read 6691 times since then.
Npgsql Data Types And Equivalents
Postgresql Type |
NpgsqlDbType |
System.DbType Enum |
.Net System Type |
---|---|---|---|
int8 |
Bigint |
Int64 |
Int64 |
bool |
Boolean |
Boolean |
Boolean |
Box, Circle, Line, LSeg, Path, Point, Polygon |
Box, Circle, Line, LSeg, Path, Point, Polygon |
Object |
Object |
bytea |
Bytea |
Binary |
Byte[] |
date |
Date |
Date |
DateTime, NpgsqlDate |
float8 |
Double |
Double |
Double |
int4 |
Integer |
Int32 |
Int32 |
money |
Money |
Decimal |
Decimal |
numeric |
Numeric |
Decimal |
Decimal |
float4 |
Real |
Single |
Single |
int2 |
Smallint |
Int16 |
Int16 |
text |
Text |
String |
String |
time |
Time |
Time |
DateTime, NpgsqlTime |
timetz |
Time |
Time |
DateTime, NpgsqlTimeTZ |
timestamp |
Timestamp |
DateTime |
DateTime, NpgsqlTimestamp |
timestamptz |
TimestampTZ |
DateTime |
DateTime, NpgsqlTimestampTZ |
interval |
Interval |
Object |
TimeSpan, NpgsqlInterval |
varchar |
Varchar |
String |
String |
inet |
Inet |
Object |
NpgsqlInet, IPAddress
|
bit |
Bit |
Boolean |
Boolean, Int32
|
uuid |
Uuid |
Guid |
Guid |
array |
Array |
Object |
Array
|
Scratching Beneath the Surface
Friday, March 11, 2022 0 1940 |
Compare Tables Row By Row in PostgreSQL
Sunday, June 21, 2015 2 14000 |
Some Helpful Links For Software Developers
Saturday, April 28, 2012 0 8022 |
Show All Functions and Views In PostgreSQL By Using Select Statement And Querying pgCatalog
Saturday, February 18, 2012 0 2483 |
DataBinding GridView In Asp.NET Application By Using PostgreSQL as DataSource
Sunday, October 10, 2010 0 12197 |
PostgreSQL - PL/pgSQL Little Code Snippets
Friday, October 08, 2010 3 5111 |
PostgreSQL 8.4.4 Data Types
Monday, September 27, 2010 0 2681 |
szamora | Reply
Saturday, March 10, 2012 10:21:41 PMReading a Polygon item from vb.net