Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading image data from PostgreSQL

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!

1 Reply
bestofwest
Contributor II

Re: Loading image data from PostgreSQL

The large object is a BLOB.

Use a program to export image first before use it location.

Is the best method.

AC

Community Browser