Yes, I want to create a jpeg/tiff file. I am new to cursors, how would that work in a query.
On 14 February 2012 15:39, Pierre Racine <[email protected]>wrote: > Thanks, > > Do you see any way to make the file directly readable (without having to > edit it)? > > Pierre > > > -----Original Message----- > > From: [email protected] [mailto: > postgis-users- > > [email protected]] On Behalf Of Sandro Santilli > > Sent: Tuesday, February 14, 2012 9:28 AM > > To: PostGIS Users Discussion > > Subject: Re: [postgis-users] ST_AsJpeg > > > > On Tue, Feb 14, 2012 at 09:22:21AM -0500, Pierre Racine wrote: > > > Yes. You want to write the file directly to the filesystem? Sandro > wrote > > something in the list about this recently but I can't find it. Sandro? > Robe? > > > > > > > I ended up binary-editing the result afterwards. > > > > Anyway, first step is declaring a binary cursor, redirecting output to a > file and > > calling the function. > > > > For the binary editing, I looked at another file with my expected format > to tell > > where it started (human eye pattern matching). > > > > > You can also use gdal_translate... > > > > Much better, when it works (it wasn't working for me). > > > > --strk; > > > > ,------o-. > > | __/ | Delivering high quality PostGIS 2.0 ! > > | / 2.0 | http://strk.keybit.net > > `-o------' > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
