X-Original-To: pgsql-sql@postgresql.org
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id E24B4475AD4
	for <pgsql-sql@postgresql.org>; Fri, 14 Mar 2003 15:06:21 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id CC0E043A611; Fri, 14 Mar 2003 15:06:21 -0500 (EST)
From: "David Delorme" <ddelorme@dmdelorme.ca>
X-Newsgroups: comp.databases.postgresql.sql
Subject: MapInfo and PostgreSQL how-to
Date: Fri, 14 Mar 2003 14:06:41 -0600
Organization: Hub.Org Networking Services (http://www.hub.org)
Lines: 47
Message-ID: <b4tcnt$2782$1@news.hub.org>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
To: pgsql-sql@postgresql.org
X-Archive-Number: 200303/373
X-Sequence-Number: 12412

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"