Hi George, I suggest you to use PyGreSQL to connect with PostgreSQL from Python: http://www.pygresql.org/
About the queries to extract the info, just check http://postgis.refractions.net/documentation/manual-1.5/reference.html Best regards, -- Jorge Arévalo Internet & Mobilty Division, DEIMOS jorge.arev...@deimos-space.com http://es.linkedin.com/in/jorgearevalo80 http://mobility.grupodeimos.com/ http://gis4free.wordpress.com http://geohash.org/ezjqgrgzz0g On Fri, Apr 15, 2011 at 11:37 AM, Marco Lechner - FOSSGIS e.V. <marco.lech...@fossgis.de> wrote: > hi georg, > > this is no postgis-specific question. You connect from python as connecting > to any postgresql-DB. You just have a bunch of postgis-functions available > on SQl-side > > Marco > > P.S. if you are familiar with python you also could write new functions in > postgreSQL using plpythonu as processing language within postgis/postgreSQL > > Am 15.04.2011 11:17, schrieb George Washington: > > Hi, I am new to postgis (1.5 under Win 7) but have read enough to feel > hopeful that it could be just what I need. I have a very large number of > shape files which I have loaded in my first postgis database generating some > hundreds of tables with vector data. So far so good, but now I need to use > it to create queries and extract information in batch using Python. I have > seen statements by people who used Python to access postgis databases but I > have not been able to find any coded examples which show : > 1) how to connect to the database > 2) how to perform queries on the data > 3) how to extract the results from the queries, etc... > > (all of which can be done in Python easily with MySql ) > > Can you please point me to any document which gives examples or code > fragments to do the above. > Many thanks, > George > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
