duckdb / duckdb/duckdb-spatial
Specify layer name for writing to FileGDB?
- Dominant language
- C
- Stars
- 708
- Forks
- 96
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 5
Description
Hey there -
Is it possible to specify a layer name (feature class or table) when writing to a file geodatabase?
The following code creates a file geodatabase named "testing" and a feature class named "testing".
```
COPY
(SELECT ST_Point(1,2) as geom, 10 as i)
TO
'./testing.gdb'
WITH (FORMAT 'GDAL',
DRIVER 'OpenFileGDB',
GEOMETRY_TYPE 'POINT',
LAYER_CREATION_OPTIONS 'LAYER_ALIAS=alias');
```
It appears, based on the [OpenFileGDB driver documentation](https://gdal.org/drivers/vector/openfilegdb.html) from GDAL, that you can specify the file geodatabase and feature class name when copying.
Thanks!
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.