save image and display image from postgresql

There is several way to save image into postgresql database. Using oid, blob and bytea data types.bytea column type recommended.

To store image

gdk_pixdata_from_pixbuf(),
gdk_pixdata_serialize()

To display image

gdk_pixdata_deserialize(),
gdk_pixbuf_from_pixdata(),
gtk_image_new_from_pixbuf()

Thanks to vivien and Yann Droneaud for great help