I have a geopackage (from the 'input' app) which is being inserted into a postgres/postGIS table via an ogr2ogr script on a daily basis:
ogr2ogr -append -f "PostgreSQL" "PG:user=xxxx host=xxxx password=xxxx dbname=xxxx" "path\Invoer.gpkg" -nln invoer --config OGR_TRUNCATE YES
The geopackage has one column (fid) that has been set to auto increment in QGIS/input on each new record made. With the above script it completely copies the table/layer including the auto-increment field default to a PostgreSQL table. The problem is that with every update the fid field recounts from the last fid in the previous (unupdated) table.
How do I change this script so that it copies the fid as a number data field that does NOT include the increment default value?