Skip to main content

Uploading images into Vertica

  • July 11, 2018
  • 1 reply
  • 3 views
dhenriquez

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

    1 reply

    skeswani
    Forum|alt.badge.img
    • skeswani
    • Participating Frequently
    • September 17, 2019

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement