Message-ID: <37FDF6C8.EEED4CE2@caiw.nl>
Date: Fri, 08 Oct 1999 15:51:04 +0200
From: Erwin van der Valk <The.Falcon@caiw.nl>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: odbc and large objects
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi there,
I have a problem with the windows 32 odbc driver for postgres.

I have written an application in visual C++ 6 that can read/write in any
table on the postgreSql server through ODBC, But now I want to put a
picture (large object) in the database. There's hardly any documentation
available on that subject. The odbc driver FAQ said I had to create a
new type, called lo, which I did, but that still get's me nowhere.

How can I read a picture from the database? Can I just use an SQL query
and select the picture from the database, or do I have to use some of
the functions in the drivers DLL?

The same thing goes for writing an image to the database. Can I just use
'insert into'??

I have read that the lo datatype is mapped to LONGVARBINARY. Does that
mean all the data is stored in the format LONGVARBINARY or just the oid?

thanx

Erwin van der Valk
falcon@caiw.nl