This is question regarding storing of image in PostgreSQL and display in OpenLayers popup through GeoServer (using WMS service).
PostgreSQL is installed in my virtual machine.
I tried to store image in my spatial table where I added new image column(bytea) then by using following query
update latlong set image = 'c:\\img.jpg' where gid = 1;
I could be able to store image but I think image not stored but its path.
Now when I click on my overlays map then I can see other attributes plus image attribute also in popup but no image just some encrypted code which I did not be able to understand.
So my first question is that if that's the correct way to store image so that I can get image attribute with image using WMS service by OpenLayers.
and second question if this is not right way then please give me some information how to accomplish that. I want to display image in popup with other attribute by using database which is PostgreSQL. Please if anyone can help I am desperate here...