2. Using Ingres Commands : blobstor Command—Copy a BLOB from a File to a Database : blobstor Examples
 
Share this page                  
blobstor Examples
This command stores a picture logo.gif into a database style in the pic column of table images:
blobstor -t images -b pic -n fname style logo.gif
Note:  To use blobstor, these two columns must exist in the table. For example:
create table images (fname varchar(256), pic long byte);\p\g
This command updates a picture into the database style in the picture column of table images:
blobstor -t images -b pic -n fname -u -w fname='logo.gif' style newlogo.gif