GM2PgSQL

Introduction

The gm2pgsqlproject is a PostgreSQL Community project that is a part of the pgFoundry.

This is a simple win32 command-line tool for exporting Geomedia(*) Warehouse (mdb Access(**) database) to Postgres-Postgis SQL file. It works like the famous shp2pgsql. The tools uses odb32lib to read mdb file and do not required to install Microsoft Access(**); in some cases you must install the free downloadable Access Runtime.

Download and Usage

You may download win32 executable or c++ source files at:

• Win32 binary executable V1.0
• C++ Source files V1.0

This is a command line (DOS) command, usage:

    gm2pgsql [options] warefile.mdb outfile.sql db_schema_name SRID
    options: -p : preserve case of names (tables and attributes)

    gm2pgsql -p USSampleData.mdb USSampleData.sql us_schema 4326

Some notes

• text feature are dumped as points plus a text field;
• oriented point are dumped as points (angle is deleted);
• no text code conversione are made (es. utf8 );
• geometry data are dumped as wkt (and not as wkb);
• arc geometry and rectangle are not supported;
• picklist and coord systems are not dumped;
• spatial key field, geometry field of texts and primary key field are inferred empirically.

Source File List and Building

• blob4.h blob4.cpp : simple Geomedia(*) blob field codec;
• rodbc2.h rodbc2.inl rodbc2.cpp : simple odbc wrapper;
• gm2pgsql.cpp : main program;
• gm2pgsql_msvcc.mak Visual C++ makefile;
• mingw/makefile: mingw gcc makefile;

Contacts