1 Reply Latest reply: Dec 23, 2014 10:45 AM by Antonio Caria RSS

    Loading image data from PostgreSQL

    Mathias Vanden Auweele

      Dear All,

       

      I'm trying to load data from a PostgreSQL database. Their is a column refering to an image stored as 'large object' (lo). Normally to get this image by using the function lo_export(). I could do a load with QlikView, loading the data first and afterwarths bundling it with the image that is exported somewhere on the server. However, I cannot get a file connection between my qlikview server and the database server. Could I in some way solve this problem by using the odbc connection to load the image directely, instead of first exporting?

       

      Thanks!