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

15 votes338 views4 answers
Create table if not exists sql
SQL
0 vote315 views1 answer
Psql generate id in existing database
SQL
0 vote324 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
8 votes361 views2 answers
Default sql server port
SQL
-1 vote314 views1 answer
Condition in orderby mysql
SQL
0 vote323 views1 answer
Trigger stock phpmyadmin
SQL
2 votes307 views1 answer
Oracle list grants on package
SQL
0 vote289 views1 answer
Replace sqlalchemy
SQL
0 vote305 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
2 votes320 views1 answer
Can you use a where clause for a child query
SQL