diff options
Diffstat (limited to 'sandbox/iter.py')
| -rw-r--r-- | sandbox/iter.py | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sandbox/iter.py b/sandbox/iter.py new file mode 100644 index 0000000..74c8aba --- /dev/null +++ b/sandbox/iter.py @@ -0,0 +1,14 @@ +import psycopg2 +import psycopg2.extras + +conn = psycopg2.connect("dbname=test") +curs = conn.cursor(cursor_factory=psycopg2.extras.DictCursor) + +curs.execute("SELECT '2005-2-12'::date AS foo, 'boo!' as bar") +for x in curs.fetchall(): + print type(x), x[0], x[1], x['foo'], x['bar'] + +curs.execute("SELECT '2005-2-12'::date AS foo, 'boo!' as bar") +for x in curs: + print type(x), x[0], x[1], x['foo'], x['bar'] + |