topic Loading image data from PostgreSQL in QlikView https://community.qlik.com/t5/QlikView/Loading-image-data-from-PostgreSQL/m-p/353938#M703771 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>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?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 16 May 2012 11:12:50 GMT 2012-05-16T11:12:50Z Loading image data from PostgreSQL https://community.qlik.com/t5/QlikView/Loading-image-data-from-PostgreSQL/m-p/353938#M703771 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>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?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 16 May 2012 11:12:50 GMT https://community.qlik.com/t5/QlikView/Loading-image-data-from-PostgreSQL/m-p/353938#M703771 2012-05-16T11:12:50Z Re: Loading image data from PostgreSQL https://community.qlik.com/t5/QlikView/Loading-image-data-from-PostgreSQL/m-p/353939#M703772 <HTML><HEAD></HEAD><BODY><P>The large object is a BLOB.</P><P></P><P>Use a program to export image first before use it location.</P><P></P><P>Is the best method.</P><P></P><P>AC</P></BODY></HTML> Tue, 23 Dec 2014 15:45:42 GMT https://community.qlik.com/t5/QlikView/Loading-image-data-from-PostgreSQL/m-p/353939#M703772 Anonymous 2014-12-23T15:45:42Z