Hi,
I'm developing a web application using Pygresql, and it's been sort of
misbehaving recently.
I use arrays in PSQL to make dynamic tables for various user actions, and often
need to find the types of the tables' columns. However, any time I try to get
the type with get_attnames, I get 'text' for all of the fields.
get_attnames outputs:
{'participants': 'text', 'score': 'text', 'victory': 'text'}
psql \d outputs:
Column | Type | Modifiers
--------------+---------------------+-----------
participants | character varying[] |
victory | boolean[] |
points | integer[] |
I don't think I'm doing anything wrong, this is my python:
self.database.get_attnames(query_string['id'][0]) # query_string['id'][0] is
the table name
Is it possible that pygresql doesn't know how to handle the arrays properly?
I'll do some digging, but if someone can spot my mistake, I'd be glad to hear
it.
--
Mark Holmquist
Student, Computer Science
University of Redlands
[email protected]
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
