NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{TOC right}}
==Importing data to PostGreSQLPostgreSQL==__NOEDITSECTION__ If you have imported data to temporary tables, you need to double-check how your data looks like after import to PostGreSQLPostgreSQL. There are changes in date format and boolean compared to MySQL.
==Configuration files==__NOEDITSECTION__
===SQL syntax===__NOEDITSECTION__
{{Note | It is strongly recommended to copy all SQL statements to a SQL tool like PGadminIII or NaviCat and test them before running the script in {{IMSMANG}} 6.0}}
Due to PostGreSQL PostgreSQL is case sensitive you need to adapt SQL statements by adding " around column names that contains capital case and because of the " you also need to add \ (escape character).
'''5.08.04 example'''
</pre>
In PostGreSQL PostgreSQL there are other reserved words than in MySQL. In your SQL tool you will see them marked with blue text. <br/>
[[Image:Reserved_word1.png|800px|center]]
<div align="center">
===Data type Byte===__NOEDITSECTION__
In PostGreSQL PostgreSQL the data type Byte has been replaced with Boolean. You find all places you need to change by searching for ''Byte''.
'''5.08.04 example'''
<pre>
