Hi there... I need to push a geojson file to Postgres (PostGIS). What is the most efficient way to do this?
One option is to write a shell command (using ogr2ogr) within a task. Is there a recommended way to do this?
FYI, ive tried using Geopandas to_postgis method but that is way too slow.
08/12/2022, 1:13 AM
Perhaps using the collection prefect-shell if you need to write a shell command within a task?