Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

The large object is a BLOB.

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

Is the best method.

AC