odbc and large objects

From: Erwin van der Valk <The(dot)Falcon(at)caiw(dot)nl>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: odbc and large objects
Date: 1999-10-08 13:51:04
Message-ID: 37FDF6C8.EEED4CE2@caiw.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)caiw(dot)nl

Browse pgsql-interfaces by date

  From Date Subject
Next Message Nigel Tamplin 1999-10-08 21:49:59 JDBC: ResultSet.updateString(int columnIndex, String x) when is this going to be implemented?
Previous Message Ravi Prasad 1999-10-08 12:00:49 Accessing Text field using ODBC and RDO