PostgreSQL types and C# types

Postgresql  NpgsqlDbType System.DbType Enum .Net System Type
----------  ------------ ------------------ ----------------
int8        Bigint       Int64              Int64
bool        Boolean      Boolean            Boolean
bytea       Bytea        Binary             Byte[]
date        Date         Date               DateTime
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
timetz      Time         Time               DateTime
timestamp   Timestamp    DateTime           DateTime
timestamptz TimestampTZ  DateTime           DateTime
interval    Interval     Object             TimeSpan
varchar     Varchar      String             String
inet        Inet         Object             IPAddress
bit         Bit          Boolean            Boolean
uuid        Uuid         Guid               Guid
array       Array        Object             Array

Source: stackoverflow.com

Similar codes

0 vote103 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote102 views1 answer
Mysql streaming example
SQL
49 votes166 views6 answers
Alter table add column
SQL
0 vote109 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote112 views1 answer
Oracle date summer time
SQL
0 vote112 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote106 views2 answers
Alter table add multiple columns mysql
SQL
0 vote70 views1 answer
Query for maximum salary
SQL
4 votes164 views1 answer
Mysql store ip address
SQL
1 vote91 views1 answer
Real world example of nosql
SQL