Florian Pflug <fgp(at)phlo(dot)org> wrote:
> On Sep28, 2011, at 15:32 , Alexander Soudakov wrote:
>> Here you can find www_fdw feature documentation:
>> http://wiki.postgresql.org/wiki/WWW_FDW
>
> Certainly looks useful (as a third-party extension, as others have
> already pointed out)
Our programmers agree that it is likely to be useful here. I agree
that it should be an extension.
> What I didn't quite understand is how one would pass (dynamic)
> parameters for a GET request. For example, not too long ago I
> needed to access the Google Maps API from postgres. I ended up
> using pl/python, and now wonder if your FDW would support that
> use-case.
I would assume that the usual ? to start parameters and & between
parameters would be used. For example, with Google Maps:
http://maps.google.com/maps?hl=en&ie=UTF8&hq=&hnear=Madison,+Dane,+Wisconsin&ll=43.074684,-89.38188&spn=0.003006,0.00383&t=h&z=18&layer=c&cbll=43.07468,-89.381742&panoid=LhJ-PFHVzxRguJ6h616mmQ&cbp=12,355.53,,0,-1.32
-Kevin