Thread

1. BLOB Type ?

   Thorsten Mauch <mauch@imkenberg.de> — 2001-04-21T20:48:30Z

   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
   
   
   
   

2. Re: BLOB Type ?

   Ryan Ho <ryanho@cyberronins.com> — 2001-04-22T15:36:12Z

   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)
   
   
   

3. Re: BLOB Type ?

   Ryan Ho <ryanho@pacific.net.sg> — 2001-04-22T16:49:07Z

   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)