Add Utility to Import/Export Shapefiles

Describe the solution you'd like

The PostGIS extension allows users to import ESRI shapefiles into tables. However, the process for doing so is inconsistent across platforms. On Windows, PostGIS includes a shapefile import/export manager application. But that application isn't available on macOS and Linux, which means users must run the shp2pgsql command-line utility, which is cumbersome due to the multiple arguments it requires.

Given that pgAdmin already allows users to import CSV and text files to tables by running COPY in the background, it would be nice if pgAdmin did similar by providing a GUI interface for shp2pgsql. Given that pgAdmin includes a helpful GIS viewer, this would make pgAdmin even more useful for GIS developers.

Describe alternatives you've considered

Can continue to use existing methods on Windows and macOS.

Additional context

I may be mistaken but I believe pgAdmin 3 had a plugin for this purpose.

This is a screenshot of the PostGIS shapefile loader, which is available for Windows but not macOS or Linux:

PgAdmin would need to detect whether a database has the PostGIS extension installed and thus has access to shp2pgsql.

Start by reviewing pgAdmin's existing CSV and text-file import flow that runs COPY in the background, then examine how shp2pgsql availability could be detected for PostGIS databases. Done means a cross-platform GUI supports shapefile import/export and avoids requiring users to assemble shp2pgsql arguments manually.