thanks for the advice.
for the curious: the problem is in reading few rows pgARRAY.

"""
Table "company"
    Column     |            Type             | Modifiers
 phone         | character varying(150)[]    | not null
...
"""

from pg8000 import DBAPI
conn = DBAPI.connect(host="localhost", user="x", password="x",
database="x")
cursor = conn.cursor()
cursor.execute("select phone from company limit 2;")
for row in cursor:
        print row

cursor.close()
conn.close()

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to