>
> 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
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',
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
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
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
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\
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 :
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
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.
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
10 matches
Mail list logo