psycopg NULL

[Diez B. Roggisch]

> # None of these work ...
> #curs.execute('INSERT INTO foo (i) VALUES (%s)' % None)
> #curs.execute('INSERT INTO foo (i) VALUES (%d)' % None)
> #curs.execute('INSERT INTO foo (i) VALUES (%i)' % None)
> #conn.commit()

> Any suggestions?

Try literal NULL - as the statement is a string, the types are figured out
by pg itself:

curs.execute('INSERT INTO foo (i) VALUES (NULL)')

-- 
Regards,

Diez B. Roggisch