pramsey / pgsql-ogr-fdw

PostgreSQL foreign data wrapper for OGR
MIT License
237 stars 34 forks source link

SQL Functions to list drivers and also version of GDAL #196

Closed robe2 closed 3 years ago

robe2 commented 3 years ago

Now that IMPORT FOREIGN SCHEMA is around, it's a bit of a nuisance to have to do a shell command to get list of drivers from ogr_fdw_info.

It would be nice if we had a function similar to the postgis raster ST_GDALDrivers - https://postgis.net/docs/RT_ST_GDALDrivers.html that lists the ogr drivers available.

One other thing that is annoying is to figure out what GDAL I am running - I have to do SELECT postgis_full_version(); (assuming I installed postgis raster) to get the version of GDAL. Sure I could get that information consoling into my server but that is soo much work and plus - I don't always have shell access to a server.

If you don't think this is scope creep I'd be willing to work on it.