Stefan Yes - It's just one line in my python file and I double-checked my quotes. -David
On Mon, Feb 20, 2012 at 6:04 PM, Stefan Keller <sfkel...@gmail.com> wrote: > David > > Just to be sure: You did make one single line without line breaks from the > mail? > > os.system('start "C:\Program Files > (x86)\PostgreSQL\9.1\bin\pgsql2shp.exe" -f D:\testShapefile.shp -h > localhost -u postgres -p 5432 test_db "SELECT * FROM > myschema.testquery"') > > -Stefan > > 2012/2/20 David Quinn <daithiqu...@gmail.com>: > > I did try that and got the following error message: > > > > "Windows cannot find '-f'. Make sure that you typed the name correctly, > and > > then try again." > > > > > > On Mon, Feb 20, 2012 at 5:49 PM, Paul Ramsey <pram...@opengeo.org> > wrote: > >> > >> Your quotes are misplaced, try > >> > >> os.system('start "C:\Program Files > (x86)\PostgreSQL\9.1\bin\pgsql2shp.exe" > >> -f > >> D:\testShapefile.shp -h localhost -u postgres -p 5432 test_db "SELECT * > >> FROM > >> myschema.testquery"') > >> > >> > >> On Mon, Feb 20, 2012 at 2:24 PM, David Quinn <daithiqu...@gmail.com> > >> wrote: > >> > I'm trying to call the pgsql2shp.exe function using python, as I would > >> > like > >> > to be able to loop through some tables. What I've tried doing is the > >> > following: > >> > > >> > import os > >> > os.system('start "C:\Program Files > >> > (x86)\PostgreSQL\9.1\bin\pgsql2shp.exe -f > >> > D:\testShapefile.shp -h localhost -u postgres -p 5432 test_db "SELECT > * > >> > FROM > >> > myschema.testquery""') > >> > > >> > When I paste the line: > >> > > >> > C:\Program Files (x86)\PostgreSQL\9.1\bin\pgsql2shp.exe -f > >> > D:\testShapefile.shp -h localhost -u postgres -p 5432 test_db "SELECT > * > >> > FROM > >> > myschema.testquery" > >> > > >> > it produces a shapefile without a problem. However, my python script > >> > flashes > >> > open a CMD terminal, but it disappears before I see what is happening > >> > and > >> > does not produce any output. I'm using PostGIS 2.0, Windows 7, and > >> > Python > >> > 2.6.5. > >> > If there is an alternative approach to python for this, I will happily > >> > try > >> > it out. > >> > > >> > (I hope this question is not too off-topic!) > >> > > >> > Thanks, > >> > David > >> > > >> > > >> > > >> > > >> > _______________________________________________ > >> > 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 > > > _______________________________________________ > 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