Changes between Version 10 and Version 11 of HowToMoveFromMySQLToPostgres

Timestamp:

Jul 13, 2009, 12:34:15 AM (15 years ago)

Author:

heikki

Comment:

--

HowToMoveFromMySQLToPostgres

@@ -117 +117 @@
  * Primary key column {{{id}}} gets called {{{ogc_fid}}} in Postgres
 
-The {{{wkb_geometry}}} columns can be fixed using this sql (thanks Thijs Brentjens) :
+The {{{wkb_geometry}}} columns can be fixed (i.e. removed) using this sql (thanks Thijs Brentjens) :
 
 {{{
@@ -152 +152 @@
 }}}
 
+TODO how to fix the IDs
+TODO how to handle Postgres / MySQL on different machines 
+TODO should we change the !GeoNetwork Postgress create-db script to match ogr2ogr's definition ?
+
+In case the {{{ogr2ogr}}} command above gave you errors related to encodings, you might try this (Thijs Brentjens) :
+
+{{{
+alter database geonetworktest set client_encoding=latin1;
+}}}