Uploading images into Vertica

dhenriquezdhenriquez
in General Discussion

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

Comments

  • 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...