[postgis-users] ST_AsJpeg

[Joan]

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 <Pierre.Racine at sbf.ulaval.ca>wrote:

> Thanks,
>
> Do you see any way to make the file directly readable (without having to
> edit it)?
>
> Pierre
>
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-
> > bounces at postgis.refractions.net] 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
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120214/857d3a8a/attachment.html>