From: David Delorme <ddelorme@dmdelorme.ca>
To: pgsql-sql@postgresql.org
Subject: MapInfo and PostgreSQL how-to
Date: Fri, 14 Mar 2003 14:06:41 -0600
Message-ID: <b4tcnt$2782$1@news.hub.org> (raw)
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"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ddelorme@dmdelorme.ca
Subject: Re: MapInfo and PostgreSQL how-to
In-Reply-To: <b4tcnt$2782$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox