Re: wriring a file to a database

On Sat, 8 Dec 2007, Roger Mason wrote:

> I want to write a file into a database from python using psycopg.

You don't use lo_import directly for that. There is an example program
included with psycopg that shows the right syntax to insert a file. For
psycopg1, see bytea.py ; for psycopg2 look at binary.py

> curs.execute("INSERT INTO diamonds VALUES (%s,
> \lo_import(%s))",(iname, image))
> psycopg2.ProgrammingError: syntax error at or near "\" at character 50

Just so you know, the commands starting with \ like \lo_import are
specific to the psql client. None of those will work if you use another
tool to connect.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD