Re: [GENERAL] BLOBS from psql...

On Wed, 4 Nov 1998, A James Lewis wrote:

>
>
> Is there any way to enter a large object (Binary) into a database using
> psql... or any other tool I can run from a shell script...

There are the lo_import and lo_export functions, but the file has to be on
the backend for them.

> Ideally I need to be able to take stdin and put it in a particular place
> in a table.... Then obviously get it back out later...

The easiest way is to write a small client using libpq that does it for
you.

I'm thinking on the lines of:

$> blob -i <my-src-file

and

$> blob -o >my-dest-file

It's been a while since I've used libpq, but there are some examples you
could hack to do this in the source tree.

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf