vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Can anyone recommend a python interface other than pygresql for postgresql. Yet again they have changed the API (pg.error is now pg.Error), and I can get no information from the mailing list, which seems dead. Thanks, Alex Turner netEconomist ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
| |||
| On Thu, Feb 10, 2005 at 01:29:42PM -0600, James Thompson wrote: > Though if IIRC it does round timestamps which can burn a person at times > I don't have a test case to verify if my memory is correct about this though. Actually, I think it's just that mxDateTime defaults to displaying times as HH:MM:SS.ss, but the extra precision does appear to be there: In psql: SELECT tm FROM foo; tm ----------------- 14:32:41.219443 In Python: curs.execute('SELECT tm FROM foo') row = curs.dictfetchone() print row['tm'] 14:32:41.21 print row['tm'].second 41.219443 -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend |
| ||||
| Alex Turner wrote: >Can anyone recommend a python interface other than pygresql for >postgresql. Yet again they have changed the API (pg.error is now >pg.Error), and I can get no information from the mailing list, which >seems dead. > > > Pyscopg is very popular. We use it hear at Command Prompt with great success. J >Thanks, > >Alex Turner >netEconomist > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > > -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |