Sorry, accidentally pressed send.
cur_p = conn_pr(cursor_factory=psycopg2.extras.DictCursor)
cur_t = conn_t.cursor(cursor_factory=psycopg2.extras.DictCursor)
cur_t.execute("""
SELECT TRANSLATE(snumber, ' ', '')
FROM sprofile """)
# This will result in KeyError
for row in cur_t:
print row['snumber']
# This works fine
for row in cur_t:
print row[0]
Sorry again.
I would really appreciate any suggestions.
Thanks,
J