Re: BLOB Type ?

From: Steve Waldman <swaldman(at)mchange(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: BLOB Type ?
Date: 2001-04-22 21:19:50
Message-ID: 20010422171950.C13394@peanut-butter.mchange.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org)

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-04-22 21:56:42 Re: Does Postgres rollback transactions on all errors?
Previous Message Ryan Ho 2001-04-22 16:50:34 Does Postgres always automatically rollback transactions when an SQL command fails?