We have this documented in the docs. http://www.postgis.org/documentation/manual-svn/using_raster.xml.html#RT_Ras ter_Applications
There is an example for doing it with PHP, .NET, Java, and PLPython Sorry don't have one for psql only. Haven't tried using psql for outputting files. Regina http://www.postgis.us > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On > Behalf Of Pierre Racine > Sent: Tuesday, February 14, 2012 11:05 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] ST_AsJpeg > > 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-Minimali > st-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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
