blob: b9975a09b3a524a1813e6f9a8a597aea1b791f46 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
import psycopg
conn = psycopg.connect("dbname=test")
curs = conn.cursor()
curs.execute("SELECT ARRAY[1,2,3] AS foo")
print curs.fetchone()
curs.execute("SELECT ARRAY['1','2','3'] AS foo")
print curs.fetchone()
curs.execute("""SELECT ARRAY['','"',''] AS foo""")
d = curs.fetchone()
print d, '->', d[0][0], d[0][1], d[0][2]
|
