[postgis-users] OGR_FDW Question

[Simon SPDBA Greener]

I have a geojson file whose contents don't have a "layer" name:

{"type":"FeatureCollection","features":.....

When I try to wrap it....

CREATE FOREIGN TABLE area (
   name     varchar(100),
   imported boolean,
   id       integer,
   geom     geometry
) SERVER "geojsonfile"
OPTIONS (layer '');

I get....

ERROR: unable to connect to layer to ""
HINT:  Does the layer exist?
SQL state: HV00R

I don't want to edit the file to add a name as this is provided by an 
external source:

{"type":"FeatureCollection",*"name": "area",*"features":....

What is the correct way to specify the foreign table OPTIONS to allow 
access to a GeoJson without a name?

regards

Simon

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210319/ac1131c5/attachment.html>