The following is necessary 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" David Delorme http://dmdelorme.ca --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 6139