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 vote331 views1 answer
Display all node label neo4j
SQL
0 vote336 views1 answer
Primary key multiple
SQL
4 votes303 views1 answer
Adding data to table in sql python
SQL
0 vote371 views1 answer
Generate sql from specific migration ef core
SQL
0 vote343 views1 answer
See the structure of a table mysql
SQL
0 vote352 views1 answer
Postgresql print sessions using the database
SQL
0 vote351 views1 answer
Declare or use variable in snowflake
SQL
0 vote321 views1 answer
Less than date query sqlachemy
SQL
0 vote331 views1 answer
Get all employee of salary if more than in sql
SQL
28 votes280 views6 answers
Distinct sql
SQL