Sunday, November 5, 2017

SQL Server and Postgres Datatypes



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                           

6 comments:

Anonymous said...

Hey There. I found your blog using msn. This is a very well written article.
I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post.
I will certainly return.

Anonymous said...

Hmm is anyone else having problems with the pictures on this blog
loading? I'm trying to figure out if its a problem on my end
or if it's the blog. Any suggestions would be greatly appreciated.

Kevin Dellinger said...

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

Anonymous said...

I 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.

Anonymous said...

I used to be suggested this website by means of my cousin. I'm no longer sure
whether this publish is written via him as no one else understand such unique about my difficulty.

You are wonderful! Thanks!

Anonymous said...

Article writing is also a excitement, if you know afterward you
can write if not it is complicated to write.

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...

Contributors