Difference between revisions of "Difference MySQL PostGreSQL"

From IMSMA Wiki
Jump to: navigation, search
Line 6: Line 6:
 
* Round off  
 
* Round off  
 
* Customised functions
 
* Customised functions
 +
 +
== Upgrading Views from mySQL to PostreSQL ==__NOEDITSECTION__
  
 
{{NavBox Technical Notes}}
 
{{NavBox Technical Notes}}
  
 
[[Category:NAA]]
 
[[Category:NAA]]

Revision as of 07:48, 19 June 2014

Ambox warning blue construction.png This page is under construction

The biggest differences are:

  • PostGreSQL is case sensitive
  • Command/function
  • Dates are stored without format in PostGreSQL
  • Round off
  • Customised functions

Upgrading Views from mySQL to PostreSQL