I'm attempting to import a GeoJSON file into PostGIS using ogr2ogr
The basic command is
ogr2ogr -f "PostgreSQL" PG:"dbname=my_db user=postgres" my_file.geojson -preserve_fid -nln geo_table -append
Using this sample how do I rewrite it so the id becomes a id Colum in the database table?
{"type":"Polygon","id":123,"coordinates":[[[100,0],[101,0],[101,1],[100,1],[100,0]]]}
Produces
ERROR 1: ERROR: setval: value 0 is out of bounds for sequence
The "real" file contains both Polygon & MultiPolygon