| From: | Roger Mason <rmason(at)esd(dot)mun(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | wriring a file to a database |
| Date: | 2007-12-08 19:02:55 |
| Message-ID: | y65fxyd3t7k.fsf@minnie.esd.mun.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I want to write a file into a database from python using psycopg. I
have tried several ways to insert the file, each gives a different
error.
File "write_images_to_db.py", line 43, in insert
curs.execute("INSERT INTO diamonds VALUES (%s, lo_import
%s)",(iname, image))
psycopg2.ProgrammingError: type "lo_import" does not exist
curs.execute("INSERT INTO diamonds VALUES (%s, \lo_import
%s)",(iname, image))
psycopg2.ProgrammingError: syntax error at or near "\" at character 50
curs.execute("INSERT INTO diamonds VALUES (%s, lo_import
(%s))",(iname, image))
psycopg2.ProgrammingError: must be superuser to use server-side
lo_import()
HINT: Anyone can use the client-side lo_import() provided by libpq.
curs.execute("INSERT INTO diamonds VALUES (%s,
\lo_import(%s))",(iname, image))
psycopg2.ProgrammingError: syntax error at or near "\" at character 50
Can someone please help out?
Thanks,
Roger
Postgresql 8.0.9 on Gentoo Linux
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2007-12-08 19:53:13 | Re: wriring a file to a database |
| Previous Message | Jan de Visser | 2007-12-08 18:23:41 | Re: postgresql startup |