From: | "Jokerman" <jokerman(at)pku(dot)co(dot)id> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | accessing large object from different computer |
Date: | 2002-02-18 12:06:32 |
Message-ID: | 000001c1b874$b52e1da0$2900a8c0@pku.co.id |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi..
i'm a newbie in postgresql and have some problem when accessing large object
(image) in postgresql from different computer.
for inserting the image into the database, i copy the image into the memory,
then querying it into the database. and it work.
i also check it with the '\lo_export' command from the psql, and it produce
a file with the same size just like the original image.
but i cannot load the image from the database into my application.
using the packet monitor program (trafshow), the query only return a small
size result.
when trying to query the image using psql using 'SELECT MY_IMAGE FROM
MY_TABLE WHERE condition', 'MY_IMAGE' field return some integer, and i think
this called by oid (cmiiw).
what method should i do to make the result of the query is returning data of
the image, not the oid?
fyi, i use borland cppbuilder to develop my application, and odbc for
connecting the client and the database server, and the 'bytea' type variable
as the type of the image field.
regards,
edward
ps: sorry for my bad english..
From | Date | Subject | |
---|---|---|---|
Next Message | Nicolas Kuhl | 2002-02-18 12:29:24 | Using Connecting to Postgresql from MS Access |
Previous Message | Eric Veldhuyzen | 2002-02-18 11:21:03 | execute permissions of stored procedures? |