The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Uploading images into Vertica

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


  • skeswaniskeswani - Select Field - Employee

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file