On Fri, May 10, 2013 at 5:24 AM, Misa Simic <misa.si...@gmail.com> wrote:
> 2013/5/10 Eduardo Morras <emorr...@yahoo.es> > >> >> Hi Nelson. I worked with images and Postgresql, and want to add some >> comments: >> >> On Thu, 9 May 2013 13:40:15 -0500 >> Nelson Green <nelsongree...@gmail.com> wrote: >> > OK, this is kind of convoluted, but I got a couple of test cases that >> work >> > for me. The steps to make the first one are below. >> > >> > First I took one of the photos and shrunk it real small using GIMP. >> >> If you want to manipulate images automatically, don't use GIMP, use >> ImageMagick(for shell scripts) or OpenCV(for C sourcecode) >> >> > Then I >> > manually converted that to a base64 encoded text file: >> > /usr/bin/base64 < test.jpg > test.64 >> >> If you must to use the pg shell, perhaps coding Misa's function in other >> language (python f.ex.) allows you directly insert the bytea. >> >> > well, with pl/python there is more power - no need to use > lo_largobejects... However solution for him is not in function because of > file is on different machine then Postgres... > > I think Nelson has found solution what works for him... > I did, but I have made note of your and Thomas's suggestions. I just wanted to be able to verify that my DDL had done what I meant with a simple insert and select. The real work will be done via a PHP front-end. Thanks everyone! > > But now, what Thomas Keller suggested sounds as very good approach if user > doesn't want to write his own client code... > > A use hint: disable toast compression for that table, images are already >> compressed, you don't need to waste time with it. > > >> > That outputs a base64 string that matches test.64. Outputting that to a >> > file and then converting it back gives me my image: >> > /usr/bin/base64 -d < output.64 > newtest.jpg >> > >> > Like I said, kind of crazy, but it satisfies me that my basic premise is >> > doable. I'll still get one of the front-end developers to whip out some >> PHP >> > just to be safe. >> > >> > Thanks to all! >> >> --- --- >> Eduardo Morras <emorr...@yahoo.es> >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
