Retrive From image server to client in postgresql database

Question

I am storing an image using l_oid (postgresql). Now i want know convert l_oid to bytea and bytea to image in front end(vb.net)

[note: i dont want to use lo_import and lo_export because i need this in client server application]

can anybody having solution to solve this?

Answer 1

Use the SQL function loread( integer integer ) to read BLOB's as bytea's. You can retrieve or insert byteas using Npgsql or write a UDF to convert the bytea to Base64 format and return those as text