Uploading images into Vertica

dhenriquez

I was wondering if it's possible to embed images as a BLOB into Vertica like you could in a SQL Server.

skeswani

skeswani@skeswani-laptop:$ create table images (p long varchar(1000000));
skeswani@skeswani-laptop:$ vsql -c "insert into images values ('$(cat Slide1.jpg | base64 --wrap=0)') ; commit;"
skeswani@skeswani-laptop:$ vsql -X -t -A -c "select * from images;" | base64 -d > Slide1.copy.jpg
skeswani@skeswani-laptop:$ md5sum Slide1.*
7fb7548351d6b4aba6105a25c8258b00 Slide1.copy.jpg
7fb7548351d6b4aba6105a25c8258b00 Slide1.jpg