Support the COLUMN_TYPES option for OpenFileGDB driver #307
BruceHarold
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I'm trying not to have 64K width text fields in my output file geodatabase, so attempting to use column_types option in the driver:
conn.sql(f"""copy (select id, try_cast(update_time as datetime) as update_time, subtype, names.primary as names_primary, class, ST_GeomFromWKB(geometry) as geom from segments) to '{outFGDB}' with (format 'GDAL', layer_name 'Segments', column_types 'id=text(32),update_time=date,subtype=text(10),names_primary=text(100)', driver 'OpenFileGDB',srs 'EPSG:4326', geometry_type 'Linestring');""")
The error: BinderException: Binder Error: Unknown option 'column_types'
Beta Was this translation helpful? Give feedback.
All reactions