Am 18.08.2016 um 16:51 schrieb D'Arcy J.M. Cain:
All good ideas but not what I meant. I can do this in pgdb:
Q = "SELECT * FROM artran WHERE glaccount = %(glaccount)s AND trdate >
%(trdate)s"
x = dict(trdate = "jan 1 2016", glaccount = "1140-0000")
res = con.execute(Q, x)
I would like to do the same thing in pg.
Ah, ok, somehow I thought you were talking about the connect parameters.
I will add the other ideas to our Trac...
What you suggest should already work in 5.0, but you must use the
query_formatted() method, not the query() method which uses Postgres
parameter notation ($1, $2 etc.)
-- Christoph
_______________________________________________
PyGreSQL mailing list
[email protected]
https://mail.vex.net/mailman/listinfo.cgi/pygresql
