As far as I know the process to resize the image is: read(bytea) -> load_to_memory(image) -> resize(image) -> recode_to_bytea(image) -> store(bytea)
You helped me with the first two. When I run the function ajustar(image) update personal set image=ajustar(image) I tried to do a direct resizing from bytea but python can't understand the hexadecimal data from bytea as an jpeg image. Though I tried with with plpython2u. Thanks 2016-10-20 19:00 GMT-05:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 10/20/2016 04:51 PM, Nahum Castro wrote: > >> Hello Adrian. >> >> The result image to replace the big one. >> > > So if you are replacing the data in a bytea column with a function that > returns bytea, why encode it? > > Unless I am missing something why not just UPDATE with the raw(bytea) > return value? > > >> I have a table with images @ 12K but, went on vacation an when returned >> someone replaced the pictures with high resolution images @6M. The app >> then become very slow and halted. >> >> I have already made the script in python to resize all the images from a >> folder before to upload to the database, so it occurred to me do the >> same but on the database. >> >> Thanks again. >> >> 2016-10-20 18:32 GMT-05:00 Adrian Klaver <adrian.kla...@aklaver.com >> <mailto:adrian.kla...@aklaver.com>>: >> >> On 10/20/2016 02:42 PM, Nahum Castro wrote: >> >> Hello, >> >> The script always returns. >> select encode(ajustar(foto), 'escape') from personal where id=193; >> encode >> ----------------------------------------------------------------- >> <PIL.Image.Image image mode=RGB size=300x347 at 0x7F08A11B1650> >> >> >> >> So what do you want it to return a where do you want to return? >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> >> >> -- >> *Nahum Castro González* >> Blvd. Perdigón 214, Brisas del Lago. >> CP 37207 >> León, Guanajuato, México >> Tel (477)1950304 >> Cel (477)1274694 >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > -- *Nahum Castro González* Blvd. Perdigón 214, Brisas del Lago. CP 37207 León, Guanajuato, México Tel (477)1950304 Cel (477)1274694
