Project: QGIS

Version: 3.44

Feature: Show dialog when importing tables via browser and give users options to control import

A new dialog will prompt users for more comprehensive import configuration when dragging layers into data sources in the QGIS Browser, emulating functionality provided by the DB Manager Plugin for data imports.
Note that this only works when a single layer is selected, and using multiple selections will continue to execute an immediate import.
A new "Import Vector Table.." context menu item is also provided to allow importing directly from the current project layers into a target schema.
The dialog options include:

  • Renaming the destination table
  • Replace destination
  • Set primary key
  • Set geometry column
  • Set destination CRS
  • Set output table comment

This work entailed refactoring a number of internal architectural elements regarding the implementation of the QGIS Browser and data providers. It partly based on efforts by @JanCaha to port the DB Manager Postgres import functionality to the QGIS Browser.
Note that this feature does not currently support Oracle databases, due to legacy functionality leveraged by the oracle data provider.

This feature was funded by City of Canning

This feature was developed by Nyall Dawson