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

8 votes361 views2 answers
Select table column name in sql
SQL
4 votes367 views2 answers
Installing sql on ubuntu
SQL
0 vote349 views1 answer
Syntax for changing column size in mysql
SQL
0 vote346 views1 answer
Can we rollback data that are deleted using DELETE
SQL
-1 vote358 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote373 views1 answer
Set column in all row mysql
SQL
1 vote395 views1 answer
Postgres left join
SQL
0 vote382 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote363 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote368 views1 answer
Sql if clause within where clause
SQL