Re: BLOB Type ? - Mailing list pgsql-novice

From Steve Waldman
Subject Re: BLOB Type ?
Date
Msg-id 20010422171950.C13394@peanut-butter.mchange.com
Whole thread Raw
In response to BLOB Type ?  (Thorsten Mauch <mauch@imkenberg.de>)
List pgsql-novice
I'm not sure if thigs have changed in 7.1, but in 7.0,
as others have said, just use the type OID for
your BLOB / long binary fields.

The JDBC side is very easy. Just use ResultSet.getBytes()
and PreparedStatements.setBytes() to get and set values.

     hope this helps,
       Steve


On Sat, Apr 21, 2001 at 10:48:30PM +0200, Thorsten Mauch wrote:
> Hi All
> I wand to save pictures in the database.
> But i didn't found blob type ?
> My client is a JDBC-Application.
> What must i do, in order to save pictures to
> the database
>
> THanx
> Thorsten
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

pgsql-novice by date:

Previous
From: Ryan Ho
Date:
Subject: Does Postgres rollback transactions on all errors?
Next
From: Tom Lane
Date:
Subject: Re: Does Postgres rollback transactions on all errors?