Skip site navigation (1) Skip section navigation (2)

Re: BLOB Type ?

From: Ryan Ho <ryanho(at)pacific(dot)net(dot)sg>
To:
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: BLOB Type ?
Date: 2001-04-22 16:49:07
Message-ID: 3AE30B83.2A6F2C13@pacific.net.sg (view raw or flat)
Thread:
Lists: pgsql-novice
I don't know much about JDBC but as far as postgres is concerned, it does
not store blobs in regular tables. Instead, you need to import the blob
into the database, obtain the OID (something like a pointer to the blob,
it's an integer), and store the OID in the regular table. Although u can
use psql to import blobs, most application's drivers should provide a
function to import the blob. For example, pg_loimport in PHP. pg_loimport
returns the OID of the blob, which is then inserted into a table.


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)


In response to

  • BLOB Type ? at 2001-04-21 20:48:30 from Thorsten Mauch

pgsql-novice by date

Next:From: Ryan HoDate: 2001-04-22 16:50:34
Subject: Does Postgres always automatically rollback transactions when an SQL command fails?
Previous:From: Ryan HoDate: 2001-04-22 16:00:11
Subject: Does Postgres rollback transactions on all errors?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group