blobstor Command—Copy a BLOB from a File to a Database
The blobstor command loads a binary large object (BLOB) into a column of an Ingres database, or stores the file name of the BLOB into a specified varchar (256) column. The BLOB is stored into a long byte column.
The blobstor command has the following format:
blobstor [-t table -b blobcol -n namecol] [-u -w whereclause] [vnode::]dbname imageFile
vnode
Specifies the virtual node where the database resides.
dbname
Specifies the database name.
imageFile
Specifies the file name of the binary object to be stored.
-t table
Specifies the name of the table to update.
-b blobcol
Specifies the name of the column to contain the BLOB. The default name is icedata.
-n namecol
Specifies the name of the column to contain the file name. The default name is icedata.
-u -w whereclause
Updates (-u) the BLOB in the location specified by the where clause (-w).