Dane, This is interesting, but I have never experienced the error that you showed the link to. I will speculate that it is limited to certain data types.
To answer Abram's question, yes, you can (in my experience) push them directly. The only errors that I have encountered were when my ODBC connection had the wrong Postgres version in the connection dialog. Otherwise, I have "pushed" probably 100 tables into postgres with no trouble. I think it is worth a try! Robert W. Burgholzer Surface Water Modeler Office of Water Supply and Planning Virginia Department of Environmental Quality [EMAIL PROTECTED] 804-698-4405 Open Source Modeling Tools: http://sourceforge.net/projects/npsource/ Web-Based Water Supply Planning Demo: http://soulswimmer.dynalias.net/models/wsdemo/demo_hsi.php -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dane Springmeyer Sent: Thursday, January 10, 2008 6:47 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Pipeline Data Model Robert and Abe, On Jan 10, 2008, at 12:48 PM, Burgholzer,Robert wrote: > If you have set up an ODBC connection to your PostgreSQL database, the > tables can be loaded into postgres from MSAccess by using Access's > "Export" function. That has also been my method for going from MS Access => Postgres. In my case I set up the ODBC connection on a windows machine then dump the non-spatial tables from postgis to then restore into postgis on a linux or mac os x machine. If you try to export the spatial tables you'll get an error like this (which I have never tried to get around): http://archives.postgresql.org/pgsql-bugs/2002-12/msg00174.php Abe asked: > But are you saying you can push the table > definitions from Access into Postgres? I am only aware of the ability to export the table with definitions of field types - nothing more... since the odbc export functionality operates on individual tables. mdbtools (see below) exports basic schema from mdbs with multiple tables but not relationships. DBcovert can export sequences and constraints but I am not sure what else. > If there are spatial columns in there, this will be > a difficulty, but the regular data will upload. Of course, any > linkages > will have to be reconstituted by hand, but it is a reasonable > method in > my experience. I bring in the spatial columns on their own shp2pgsql. Converting both attribute and spatial columns using shp2pgql is not ideal because of the hassle of having all column names chopped off at 10 characters at the shp/dbf step. I've tried ogr2ogr with the PGEO driver but at this point bugs in the mbdtools dependency have made that a *real* challenge. It currently only feasible on a windows machine: http://www.postgis.org/pipermail/postgis-users/2006-October/013651.html If anyone makes progress on this front do post more ideas. I can tell from list archives that there is good reasons to avoid thinking of postgis as a file converter, but this MDB => Postgis issue is bound to require more and more attention as people discover postgis. Cheers, Dane > > Robert W. Burgholzer > Surface Water Modeler > Office of Water Supply and Planning > Virginia Department of Environmental Quality > [EMAIL PROTECTED] > 804-698-4405 > Open Source Modeling Tools for NPS analysis and Water Supply Planning: > http://sourceforge.net/projects/npsource/ > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > George Silva > Sent: Thursday, January 10, 2008 3:10 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Pipeline Data Model > > Abe, here is the XML file. Its a product of ArcGis Diagrammer. > > Note: this is APDM version 2. I cant seem to build in version 4. Ill > look into it. > > If you do build that code, i would to see it very much ;) > > Att. > > George > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
