[postgis-users] ST_AsJpeg

[Sandro Santilli]

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------'