NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "{{TOC right}} ==Importing data to PostGreSQL==__NOEDITSECTION__ If you have imported data to temporary tables, you need to double-check how your data looks like after import ..."
{{TOC right}}
==Importing data to PostGreSQL==__NOEDITSECTION__
If you have imported data to temporary tables, you need to double-check how your data looks like after import to PostGreSQL. There are changes in date format and boolean compared to MySQL.
==Configuration files==__NOEDITSECTION__
Compared to {{IMSMANG}} 5.08.04 these rows are changed:
# MIGRATION_FROM_TYPE=6.0
# MIGRATION_TO_TYPE=6.0
# IMSMA_6.0_JDBC_URL=jdbc:postgresql://localhost:5432/imsma
# IMSMA_6.0_Driver=org.postgresql.Driver
# IMSMA_6.0_User=imsma
# IMSMA_6.0_Password=password
==Scripts==__NOEDITSECTION__
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).
'''5.08.04 example'''
<pre>
SELECT Loc_VillageGUID, mMREID FROM loc_link_mre WHERE loc_link_mre.Loc_VillageGUID IS NOT NULL
</pre>
'''need to be changed to'''
<pre>
SELECT \"Loc_VillageGUID\", \"mMREID\" FROM loc_link_mre WHERE \"Loc_VillageGUID\" IS NOT NULL
</pre>
[[Category:NAA]]
==Importing data to PostGreSQL==__NOEDITSECTION__
If you have imported data to temporary tables, you need to double-check how your data looks like after import to PostGreSQL. There are changes in date format and boolean compared to MySQL.
==Configuration files==__NOEDITSECTION__
Compared to {{IMSMANG}} 5.08.04 these rows are changed:
# MIGRATION_FROM_TYPE=6.0
# MIGRATION_TO_TYPE=6.0
# IMSMA_6.0_JDBC_URL=jdbc:postgresql://localhost:5432/imsma
# IMSMA_6.0_Driver=org.postgresql.Driver
# IMSMA_6.0_User=imsma
# IMSMA_6.0_Password=password
==Scripts==__NOEDITSECTION__
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).
'''5.08.04 example'''
<pre>
SELECT Loc_VillageGUID, mMREID FROM loc_link_mre WHERE loc_link_mre.Loc_VillageGUID IS NOT NULL
</pre>
'''need to be changed to'''
<pre>
SELECT \"Loc_VillageGUID\", \"mMREID\" FROM loc_link_mre WHERE \"Loc_VillageGUID\" IS NOT NULL
</pre>
[[Category:NAA]]
