Store Image Into Postgresql Bytea Field Using Yii

Yii 1.1 General Discussion
1

Hi,

I am trying to store image into postgresql bytea field.

$data=file_get_contents("filename.jpg");

pg_escape_bytea($data);

Then I am inserting this into database. After that when I select the image from the database it is showing Resource_id #. If I use pg_unescape_bytea() on the selected field then it is showing null value. How can I store and retreive data from postgresql using yii? Please help.

Thanks in advance.