Re: BLOB Type ?

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@postgresql.org)