MapInfo and PostgreSQL how-to

The following is nessary to use mapinfo with a postgresql back end.

- Table: mapinfo.mapinfo_mapcatalog
CREATE TABLE mapinfo.mapinfo_mapcatalog (
spatialtype float8,
tablename varchar(32),
ownername varchar(32),
spatialcolumn varchar(32),
db_x_ll float8,
db_y_ll float8,
db_x_ur float8,
db_y_ur float8,
coordinatesystem varchar(254),
symbol varchar(254),
xcolumnname varchar(32),
ycolumnname varchar(32)
) WITH OIDS;
REVOKE ALL ON TABLE mapinfo.mapinfo_mapcatalog FROM PUBLIC;
GRANT ALL ON TABLE mapinfo.mapinfo_mapcatalog TO "MAPINFO";

- View: "MAPINFO"."MAPINFO_MAPCATALOG"
CREATE VIEW "MAPINFO"."MAPINFO_MAPCATALOG" AS
SELECT mapinfo_mapcatalog.spatialtype AS "SPATIALTYPE",
mapinfo_mapcatalog.tablename AS "TABLENAME",
mapinfo_mapcatalog.tablename,
mapinfo_mapcatalog.ownername AS "OWNERNAME",
mapinfo_mapcatalog.ownername,
mapinfo_mapcatalog.spatialcolumn AS "SPATIALCOLUMN",
mapinfo_mapcatalog.db_x_ll AS "DB_X_LL",
mapinfo_mapcatalog.db_y_ll AS "DB_Y_LL",
mapinfo_mapcatalog.db_x_ur AS "DB_X_UR",
mapinfo_mapcatalog.db_y_ur AS "DB_Y_UR",
mapinfo_mapcatalog.coordinatesystem AS "COORDINATESYSTEM",
mapinfo_mapcatalog.symbol AS "SYMBOL",
mapinfo_mapcatalog.xcolumnname AS "XCOLUMNNAME",
mapinfo_mapcatalog.ycolumnname AS "YCOLUMNNAME"
FROM mapinfo.mapinfo_mapcatalog;

create data tables in "MAPINFO" schema
create odbc conection as user "MAPINFO"