The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

PostgreSQL Data Types Mapping

XPO creates these column types when updating the PostgreSQL database schema and expects them in existing databases.

.NET Type Database Column Type
Boolean bool
Byte smallint
SByte smallint
Char char(1)
Decimal decimal(28,8)
Double double precision
Single real
Int16 smallint
UInt16 numeric(5,0)
Int32 int
UInt32 numeric(10,0)
Int64 bigint
UInt64 numeric(20,0)
Guid uuid
String varchar
DateTime timestamp
TimeSpan double precision
Byte[] bytea
Unlimited size string text
See Also