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  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@retep.org.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