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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.