So you might have to write a script connecting to PostgreSQL and writing the file for you. See an example in:
http://www.bostongis.com/blog/index.php?/archives/175-Minimalist-Web-based-PHP-PostGIS-2.0-Spatial-GeometryRaster-Viewer.html Pierre > -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Joan > Sent: Tuesday, February 14, 2012 10:10 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] ST_AsJpeg > > 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
