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 vote132 views3 answers
How to run sql query
SQL
1 vote127 views1 answer
Mysql size int
SQL
0 vote138 views1 answer
Psql check if sql script is valid
SQL
0 vote125 views1 answer
How to order result of subquery in select
SQL
0 vote126 views1 answer
Mysql date format unix timestamp
SQL
0 vote137 views1 answer
Sql query to find duplicate email address
SQL
0 vote132 views1 answer
Sql select where more than one record exists
SQL
1 vote149 views1 answer
How do you use sql in you company
SQL
0 vote122 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote121 views2 answers
Group_concat limit mysql
SQL