Difference MySQL PostGreSQL

From IMSMA Wiki
Revision as of 07:55, 19 June 2014 by Evinek (talk | contribs)
Jump to: navigation, search
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

When upgrading from IMSMANG 5.08.04 to 6.0, the database views need to be adapted, i.e. changed from mySQL syntax to PostgreSQL syntax. The country focal point is taking care of this. For reference, this section describes the main changes encountered. This can also be used as a tutorial for creating views in PostgreSQL, for IMSMANG administrators who were used to creating them in mySQL.

Case sensitivity and column names

The GROUP BY clause

IF and IFNULL (mySQL) / CASE (PostgreSQL) statements

Date manipulations

CAST AS CHAR utf8 (mySQL)

Technical Notes
FAQ
A - E
F - P
Q - Z
Known issues
Workarounds
Misc
Languages
Countries
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Difference_MySQL_PostGreSQL&oldid=15481"