All Questions
Tagged with python-2.7 postgresql
7 questions
0
votes
1
answer
284
views
GeoNode change uploaded directory path
I am new to GeoNode. I installed GeoNode stable version from apt-get install geonode on Ubuntu 14, and its working properly. Now I want to change the uploaded directory to /home/user/uploaded
I ...
- 215
1
vote
0
answers
2k
views
Trying to install PyGreSQL, receiving DLL load failed error
I am trying to install the PyGreSQL package into Python 2.7. I am running 32-bit Python on a 64-bit Windows 7 machine. The installer I am using is the file PyGreSQL-4.1.1.win32-py2.7.exe from here.
...
- 301
3
votes
3
answers
7k
views
How to load GeoJSON into PostgreSQL database using Python?
What I have tried to do is (In Python IDLE):
import psycopg2
import json
try:
conn = psycopg2.connect("dbname='carto' user='postgres' host= localhost password='password'")
except:
print "I am ...
- 31
3
votes
2
answers
24k
views
How to save results of postgresql to csv/excel file using psycopg2?
I use driving_distance in postgresql to find distances between all nodes, and here's my python script in pyscripter,
import sys
#set up psycopg2 environment
import psycopg2
#driving_distance module
...
- 1,565
2
votes
1
answer
32k
views
Use psycopg2 to do loop in postgresql
I use postgresql 8.4 to route a river network, and I want to use psycopg2 to loop through all data points in my river network.
#set up python and postgresql connection
import psycopg2
query = """
...
- 1,565
1
vote
1
answer
17k
views
How to execute sql lines in postgresql using python？
I use postgresql 8.4 to route a river network, the following is my code typed in pgAdmin and the result is fine,
select * from driving_distance
('select gid as id,
start_id::int4 as source, end_id::...
- 1,565
0
votes
1
answer
56
views
How to make a vectorlayer through of sentence SQL on PostGRES
How do I create a vectorlayer to through SQL on PostGiS on Python 2.7. I is working with QGIS 1.8 and I needed create a vectorLayer through SQL on PostGIS.
- 1