PostgreSQL DotNet DataType Mapping
Here’s a list of .NET datatypes, and how best to store each one.
|
.NET Datatype |
PostGreSQL DataType |
|---|---|
|
datetime (UTC) |
timestamp without time zone |
|
Guid |
uuid |
|
float |
real |
|
double |
double precision |
|
bool |
boolean |
|
decimal |
numeric |
|
string (unlimited size) |
text COLLATE pg_catalog."default" |
|
string (limited but unfixed) |
character varying(50) COLLATE pg_catalog."default" |
|
int32 |
integer |
|
int64 |
bigint |
|
DMClassName (string) |
character varying(50) COLLATE pg_catalog."default" |
|
DMClassVer (int) |
integer NOT NULL |
|
Id (Guid) |
uuid NOT NULL |
|
Id (int) |
integer NOT NULL |
|
Phone Number (string) |
character varying(20) COLLATE pg_catalog."default" |
|
Company (string) |
character varying(100) COLLATE pg_catalog."default" |
|
IconName (string) |
character varying(50) COLLATE pg_catalog."default" |
No Comments