NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
==Scripts==__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 is case sensitive you need to adopt SQL statements by adding " around column names that contains capital case and because of the " you also need to add \ (escape character).
SELECT \"Loc_VillageGUID\", \"mMREID\" FROM loc_link_mre WHERE \"Loc_VillageGUID\" IS NOT NULL
</pre>
In PostGreSQL there are other reserved word than in MySQL. In your SQL tool you will see them marked with blue text.
[[Image:Reserved_word1.png|800px]]
<div align="center">
''How it looks like in SQL tool before correction''
</div>
[[Image:Reserved_word2.png|800px]]
<div align="center">
''How it looks like in SQL tool after correction''
</div>
[[Image:Reserved_word3.png|800px]]
<div align="center">
''How it looks like in integrated into the script''
</div>
=== Data type Byte===__NOEDITSECTION__
In PostGreSQL the data type Byte has been replaced with Boolean. You find all places you need to change by searching for ''Byte''.