I’m sure everybody is aware you can have PostgreSQL fetch data live across the internet (or locally of course) as part of your queries and use the data directly. In fact there are a large number of drivers available to access different kinds of data for download. But in the simplest case, we can also just use the file_fdw
wrapper that’s included in the standard PostgreSQL packages, together with everybody’s http-swiss-army-knife, curl
.
In attempting to adapt this ... [continue reading]