| 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...
-
query execution in the production taking long time one of the query in the production taking almost 40 minutes instead seconds where it us...
-
SQL Server Data Masking : Download code DataMasking.sql Masking data can be done through updating the confidential information in t...
-
Pivot without Aggregating with consistent and inconsistent formats: One of the most common tasks which I came across at least once in almo...
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