Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
The large object is a BLOB.
Use a program to export image first before use it location.
Is the best method.
AC