How can you fix the SQL-statement in Python?
The db connection works. However, cur.execute
returns none which is false.
My code
import os, pg, sys, re, psycopg2
try:
conn = psycopg2.connect("dbname='tk' host='localhost' port='5432' user='naa' password='123'")
except: print "unable to connect to db"
cur = conn.cursor()
print cur.execute("SELECT * FROM courses") # problem here
The SQL-command in Psql returns me the correct output.
I can similarly run INSERT
in Psql, but not by Python's scripts.
I get no warning/error to /var/log.
Possible bugs are
You have to call one of the fetch
methods on cur
(fetchone, fetchmany, fetchall) to actually get the results of the query.
You should probably have a read through the a tutorial for DB-API.