On Mon, 2004-11-22 at 19:11 +0530, sreejith s wrote: > Hello friends I have a doubt, > Is it possible to insert images into a postgres db. What is its > datatype. Is its possible to insert jpeg images. or v have to store > the path into the db. Pls reply. its urgent.
Use bytea for a datatype. PostgreSQL can comfortably handle 50MB's worth of data and uncomfortably handle 1GB if you have enough RAM per tuple. You will need to properly escape the data to do the insertion, but the documentation (for DBI, PHP, Java, and PostgreSQL for the others) all clearly explain the steps to be taken. -- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
