From: Erwin van der Valk <The.Falcon@caiw.nl>
To: pgsql-interfaces@postgresql.org
Subject: odbc and large objects
Date: Fri, 08 Oct 1999 15:51:04 +0200
Message-ID: <37FDF6C8.EEED4CE2@caiw.nl> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: The.Falcon@caiw.nl
Subject: Re: odbc and large objects
In-Reply-To: <37FDF6C8.EEED4CE2@caiw.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox