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 of 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...Thanks in advance.
Best Regards, ADK