[mapguide-users] Help needed on data migration for MapGuide

[Gabriele Monfardini]

Hi,

shp2pgsql is quite powerful.
It let you choose destination table, can automatically insert geometry
column in the geometry_columns table (which is needed for Mapguide to
"see" your table, after purging the feature source) and can
automatically create a spatial index on the geometry field (which is
almost always a good idea).
You also can choose the reference system and so on.

The only possible difficulty is that PostgreSQL will reject your
shapefile if it contains in the dbf file characters which are not
valid in the character set of the server.
So if you have your PostgreSQL in utf8 and try to import a shapefile
created with latin1 it may be rejected.

There are some options to cope with this in shp2pgsql or you can
convert your shapefile to match the character set of your server.

http://postgis.refractions.net/documentation/manual-1.5/ch04.html §4.4.2

Regards,

Gabriele Monfardini