The last two solutions result in a black square, which I think is the tile. But it's a good start. I will have to look more into that. <div>Regina, I have tried using \g to out put to a file but the file is corrupted.<br>
<div><br></div><div>I appreciate the help.</div><div><br></div><div>Joan</div><div><br><div class="gmail_quote">On 14 February 2012 21:27, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">We have this documented in the docs.<br>
<br>
<a href="http://www.postgis.org/documentation/manual-svn/using_raster.xml.html#RT_Ras" target="_blank">http://www.postgis.org/documentation/manual-svn/using_raster.xml.html#RT_Ras</a>ter_Applications<br>
<br>
There is an example for doing it with PHP, .NET, Java, and PLPython<br>
<br>
Sorry don't have one for psql only. Haven't tried using psql for outputting<br>
files.<br>
<br>
Regina<br>
<a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><br>
<div class="im HOEnZb"><br>
<br>
<br>
<br>
<br>
> -----Original Message-----<br>
> From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
> [mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On<br>
</div><div class="im HOEnZb">> Behalf Of Pierre Racine<br>
> Sent: Tuesday, February 14, 2012 11:05 AM<br>
> To: PostGIS Users Discussion<br>
> Subject: Re: [postgis-users] ST_AsJpeg<br>
><br>
</div><div class="HOEnZb"><div class="h5">> So you might have to write a script connecting to PostgreSQL<br>
> and writing the file for you. See an example in:<br>
><br>
> <a href="http://www.bostongis.com/blog/index.php?/archives/175-Minimali" target="_blank">http://www.bostongis.com/blog/index.php?/archives/175-Minimali</a><br>
> st-Web-based-PHP-PostGIS-2.0-Spatial-GeometryRaster-Viewer.html<br>
><br>
> Pierre<br>
><br>
> > -----Original Message-----<br>
> > From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
> > [mailto:<a href="mailto:postgis-users-">postgis-users-</a> <a href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On<br>
> Behalf Of<br>
> > Joan<br>
> > Sent: Tuesday, February 14, 2012 10:10 AM<br>
> > To: PostGIS Users Discussion<br>
> > Subject: Re: [postgis-users] ST_AsJpeg<br>
> ><br>
> > Yes, I want to create a jpeg/tiff file. I am new to<br>
> cursors, how would<br>
> > that work in a query.<br>
> ><br>
> ><br>
> > On 14 February 2012 15:39, Pierre Racine<br>
> <<a href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</a>> wrote:<br>
> ><br>
> ><br>
> > Thanks,<br>
> ><br>
> > Do you see any way to make the file directly readable<br>
> (without having<br>
> > to edit it)?<br>
> ><br>
> ><br>
> > Pierre<br>
> ><br>
> > > -----Original Message-----<br>
> > > From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
> > [mailto:<a href="mailto:postgis-">postgis-</a><br>
> > users-<br>
> ><br>
> > > <a href="mailto:bounces@postgis.refractions.net">bounces@postgis.refractions.net</a>] On Behalf Of Sandro Santilli<br>
> > > Sent: Tuesday, February 14, 2012 9:28 AM<br>
> > > To: PostGIS Users Discussion<br>
> ><br>
> > > Subject: Re: [postgis-users] ST_AsJpeg<br>
> > ><br>
> > > On Tue, Feb 14, 2012 at 09:22:21AM -0500, Pierre Racine wrote:<br>
> > > > Yes. You want to write the file directly to the filesystem?<br>
> > Sandro wrote<br>
> > > something in the list about this recently but I can't<br>
> find it. Sandro?<br>
> > Robe?<br>
> > > ><br>
> > ><br>
> > > I ended up binary-editing the result afterwards.<br>
> > ><br>
> > > Anyway, first step is declaring a binary cursor,<br>
> redirecting output<br>
> > to a file and<br>
> > > calling the function.<br>
> > ><br>
> > > For the binary editing, I looked at another file with<br>
> my expected<br>
> > format to tell<br>
> > > where it started (human eye pattern matching).<br>
> > ><br>
> > > > You can also use gdal_translate...<br>
> > ><br>
> > > Much better, when it works (it wasn't working for me).<br>
> > ><br>
> > > --strk;<br>
> > ><br>
> > > ,------o-.<br>
> > > | __/ | Delivering high quality PostGIS 2.0 !<br>
> > > | / 2.0 | <a href="http://strk.keybit.net" target="_blank">http://strk.keybit.net</a><br>
> > > `-o------'<br>
> > ><br>
> > > _______________________________________________<br>
> > > postgis-users mailing list<br>
> > > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> > > <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
> > _______________________________________________<br>
> > postgis-users mailing list<br>
> > <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> > <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
> ><br>
> ><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br></div></div>