Thread: BLOB help needed...
We’re implementing our first PostgreSQL database, and enjoying it very much. However, we have a table that will store binary image files (pie charts, etc.) for later display on a dynamic webpage. While we’re putting together our prototype application, I’ve been asked by the programmers (I’m the DBA) to “put the images in the database.” I can see how to do this using Large Objects, but then getting them out again seems problematic, and the documentation is a bit sketchy. Would BYTEA columns be better? However, it seems to me that there is no easy way using psql to load images into a BYTEA column. Any help would be greatly appreciated.
Regards,
Mark Taber
State of California
Department of Finance
Infrastructure & Architecture Unit
916.323.3104 x 2945
If you are using php, the two functions below should help. http://ca.php.net/manual/en/function.pg-escape-bytea.php http://ca.php.net/manual/en/function.pg-unescape-bytea.php Taber, Mark wrote: > We’re implementing our first PostgreSQL database, and enjoying it very > much. However, we have a table that will store binary image files (pie > charts, etc.) for later display on a dynamic webpage. While we’re > putting together our prototype application, I’ve been asked by the > programmers (I’m the DBA) to “put the images in the database.” I can > see how to do this using Large Objects, but then getting them out > again seems problematic, and the documentation is a bit sketchy. Would > BYTEA columns be better? However, it seems to me that there is no easy > way using psql to load images into a BYTEA column. Any help would be > greatly appreciated. > > Regards, > > Mark Taber > > State of California > > Department of Finance > > Infrastructure & Architecture Unit > > 916.323.3104 x 2945 >
Hi, i wrote a php skript to test this, works beautiful, you can download the script at http://www.erdtrabant.de/index.php?i=500200104 volker Guy Fraser wrote: > If you are using php, the two functions below should help. > > http://ca.php.net/manual/en/function.pg-escape-bytea.php > http://ca.php.net/manual/en/function.pg-unescape-bytea.php > > Taber, Mark wrote: > >> We’re implementing our first PostgreSQL database, and enjoying it >> very much. However, we have a table that will store binary image >> files (pie charts, etc.) for later display on a dynamic webpage. >> While we’re putting together our prototype application, I’ve been >> asked by the programmers (I’m the DBA) to “put the images in the >> database.” I can see how to do this using Large Objects, but then >> getting them out again seems problematic, and the documentation is a >> bit sketchy. Would BYTEA columns be better? However, it seems to me >> that there is no easy way using psql to load images into a BYTEA >> column. Any help would be greatly appreciated. >> >> Regards, >> >> Mark Taber >> >> State of California >> >> Department of Finance >> >> Infrastructure & Architecture Unit >> >> 916.323.3104 x 2945 >> > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >