Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread David Quinn
> > Watch out for the escaping for Windows paths. You should have one of these: > > 'D:\\testShapefile.shp' > r'D:\testShapefile.shp' (I prefer this method) > 'D:/testShapefile.shp' (I think this works) > > As you have it, it will be "D:[tab]estShapefile.shp" with the tab > character. I don't think

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread Mike Toews
On 21 February 2012 13:39, David Quinn wrote: > Thanks for the link, Stefan. After testing out a few approaches this worked: > > import subprocess > subprocess.call(['C:/Program Files (x86)/PostgreSQL/9.1/bin/pgsql2shp.exe', > '-f', 'D:\testShapefile.shp', '-h localhost', '-u postgres', '-p 5434',

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread David Quinn
Thanks for the link, Stefan. After testing out a few approaches this worked: import subprocess subprocess.call(['C:/Program Files (x86)/PostgreSQL/9.1/bin/pgsql2shp.exe', '-f', 'D:\testShapefile.shp', '-h localhost', '-u postgres', '-p 5434', 'test_db', 'SELECT * FROM myschema.testquery']) -Davi

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread Stefan Keller
Yes; it's most probably a quoting problem: See e.g. http://stackoverflow.com/questions/204017/how-do-i-execute-a-program-from-python-os-system-fails-due-to-spaces-in-path -Stefan 2012/2/21 Horst Düster : > Be careful with the double quotes > > Dr. Horst Düster > Kappasys > Alte Bernstrasse 13 > C

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread Horst Düster
Be careful with the double quotes Dr. Horst Düster Kappasys Alte Bernstrasse 13 CH-4500 Solothurn Tel.: +41 (0) 32 514 00 40 Mobil: +41 (0) 76 408 51 06 eMail: horst.dues...@kappasys.ch skype: horstduester Twitter: moazagotl Web: www.kappasys.ch lat: N 47° 12' 06.408" lon: E 7° 32' 13.740" Am

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread David Quinn
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 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\

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread Stefan Keller
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 :

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread David Quinn
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 wrote: > Your quotes are misplaced, try > > os.system('start "C:\Program Files (x86)\PostgreSQL\9.1\bin\p

Re: [postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread Paul Ramsey
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 wrote: > I'm trying to call the pgsql2shp.

[postgis-users] Calling pgsql2shp.exe via python

2012-02-20 Thread David Quinn
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 t