I try to setup a table with one column has pictures. The client side will
be on windows.
By follow the instruction on the ODBC site I setup a new type lo on the
database.
I was able to export some MS Access table with imageobject
in one of the columns to the PostgreSQL server running on a linux
server. And I could import the table back with the imageobject.
I would like to write a client in Python to do the same thing.
Here is my problems and question:
1)When I creat table using this with psql :
CREATE table image(id integer, image oid)
and insert a image using this:
Insert into image(1, lo_import('\tmp\picture1.jpb')
Then I go back to windows and use access import the table image, all I get
is the (1, 16678) not the picture itself.
I said Ok, I will create a table from psql on the server like this:
CREATE table image(id integer, image lo)
now I do not know how to insert a record from there.
2)When I try to wirte the client myself, what command I should use to
retrieve a table with one column a image? if I fetchall() the image table
I will get (1, 16678), how do I get the image?
Could anybody give me some example or idea on how to do this.
Thanks.
Wenhua