| SQL Server | Postgres |
| bigint | numeric(20,0) |
| binary | bytea |
| bit | numeric(1,0) |
| char | character(10) |
| date | date |
| datetime | timestamp without time zone |
| datetime2 | timestamp(6) without time zone |
| datetimeoffset | timestamp(6) with time zone |
| decimal | numeric(18,0) |
| float | double precision |
| geography | character varying(8000) |
| geometry | character varying(8000) |
| hierarchyid | character varying(8000) |
| image | bytea |
| money | numeric(19,4) |
| nchar | character(10) |
| ntext | text |
| numeric | numeric(18,0) |
| nvarchar | character varying(10) |
| real | double precision |
| smalldatetime | timestamp without time zone |
| smallint | numeric(5,0) |
| smallmoney | numeric(10,4) |
| sql_variant | character varying(8000) |
| sysname | character varying(128) |
| text | text |
| time | time(6) without time zone |
| timestamp | character varying(8000) |
| tinyint | numeric(5,0) |
| uniqueidentifier | uuid |
| varbinary | bytea |
| varchar | character varying(10) |
| xml | xml |
Sunday, November 5, 2017
SQL Server and Postgres Datatypes
Subscribe to:
Post Comments (Atom)
Featured Post
SQL Server AWS Migration BCP
stored procedure to generate BCP scritps to migrate the SQL Server database. Developed this stored procedure on my labs to simulate t...
-
Pivot without Aggregating with consistent and inconsistent formats: One of the most common tasks which I came across at least once in almo...
-
SQL Server Enhancements in Mind Map
-
merge data in one table from another COPY THE CODE FROM BELOW TEXT BOX create table test_1(iid int,vname varchar(90)) create table test...
Hi, Neat post. There's a problem along with your website in internet explorer, may check this? IE still is the marketplace chief and a big element of other folks will pass over your magnificent writing because of this problem. You can look here: How Not To Lock Files
ReplyDeleteI think the admin of this site is in fact working hard in favor of his web page, for the reason that here every material is quality based information.
ReplyDeleteI used to be suggested this website by means of my cousin. I'm no longer sure
ReplyDeletewhether this publish is written via him as no one else understand such unique about my difficulty.
You are wonderful! Thanks!
Article writing is also a excitement, if you know afterward you
ReplyDeletecan write if not it is complicated to write.
Thank you so much for exploring the best and right information.
ReplyDeleteSSIS PostgreSql Write