Improve handling of import options in Export to PostgreSQL ogr2ogr

[NyakudyaA]

Feature description

Currently when importing a dataset into PostgreSQL using the ogr2ogr algorithm, if you set the following:

By default, the other option for converting to multi is also set i.e

This will lead to a command line being generated like

ogr2ogr -progress --config PG_USE_COPY YES -f PostgreSQL "PG:dbname='gis' host=localhost port=5432 user='docker' password='docker' sslmode=allow active_schema=public" -lco DIM=2 /Applications/QGIS.app/Contents/Resources/resources/data/world_map.gpkg countries -overwrite -nlt POLYGON -lco GEOMETRY_NAME=geom -lco FID=id -nln public.countries -nlt PROMOTE_TO_MULTI

This leads to having

 -nlt POLYGON  -nlt PROMOTE_TO_MULTI

Additional context

You can always untick the Promote to MultiPart so your algorithm works properly. I think it would make sense to implement the following logic

Solution A

• If the geometry type is unset then we default to have Promote to Multipart active by default

Solution B

• If the geometry type option is selected then deactivate Promote to Multipart

Solution C

• by default have the Promote to Multipart deactivated

Note There are other options like overwriting the existing table and appending to an existing table that should be mutually exclusive