I am inserting geopackage to a table in the PostgreSQL if a certain value is not null with the following comment
ogr2ogr -append -nln pgtablename -f PostgreSQL "PG:host=xx user=xx dbname=xx password=xx" E:\workspace\DATA_WORK\data\edit\70319.gpkg Bauwerkslinie -sql "SELECT * from Bauwerkslinie where begehung_von IS NOT NULL"
It works as expected. In the table
pgtablename, there is a column that I do not have in gpkg
transactionid and I would like to insert a value, that will be always the same for the affected objects in the command above.
Any idea how can I do it?