>I am searching for tutorials to store and properly display images using >php-postgresql! > >What data type must be the image collumn on my database? >how can i display the images ? >how can i control the size of the stored image? To include large objects (like images) in the database you need to use BLOBs, I think the type for postgresql is "bytea". Check the docs. I seem to remember that you inserted them by means of "lo_import" and extracted them via "lo_export". I am designing an application that needs images (who doesn't?) but I have decided to store the images separately as usual images (gif, jpg) and store in the database the link to those images, so I read the link from the database and the php script loads the image from the link. I don't have any special requirement for the security of the images, that is, if you knew the link yourself you could load it in the browser but that is not important. Adrian Tineo
