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),
spatialcolumnvarchar(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" ASSELECT mapinfo_mapcatalog.spatialtype AS "SPATIALTYPE",
mapinfo_mapcatalog.tablenameAS "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.xcolumnnameAS "XCOLUMNNAME", mapinfo_mapcatalog.ycolumnname AS "YCOLUMNNAME" FROM
mapinfo.mapinfo_mapcatalog;


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