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
-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda@postgresql.org)
Para cambiar tu suscripci�n:
http://www.postgresql.org/mailpref/pgsql-es-ayuda
