search

pramsey / pgsql-ogr-fdw

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

IMPORT FOREIGN SCHEMA gets wonky when presented with a server name that requires double quoting #190

Closed rhysallister closed 4 years ago

rhysallister commented 4 years ago

It looks as if the query generated by IMPORT FOREIGN SCHEMA adds a few too many double quotes to the server name.

image To replicate:

CREATE SCHEMA cyclonic; 
CREATE SERVER "AL012020_001Aadv_TRACK.kmz" FOREIGN DATA WRAPPER ogr_fdw 
       options (
           datasource '/vsicurl/https://www.nhc.noaa.gov/storm_graphics/api/AL012020_001Aadv_TRACK.kmz', 
           format 'LIBKML');
IMPORT FOREIGN SCHEMA ogr_all FROM SERVER "AL012020_001Aadv_TRACK.kmz" INTO cyclonic;