PostGIS data loader / dumper - GSOC 2022 Idea - Mailing list pgadmin-hackers

From Regina Obe
Subject PostGIS data loader / dumper - GSOC 2022 Idea
Date
Msg-id 001801d825e3$335df870$9a19e950$@pcorp.us
Whole thread Raw
Responses Re: PostGIS data loader / dumper - GSOC 2022 Idea
List pgadmin-hackers
In pgAdmin3, our ESRI shapefile loader /dumper GUI was installable as a
plugin.  We lost that feature with pgAdmin4.

To get this feature back, I was thinking that our command line tools would
be easier to integrate in pgAdmin4 than the gui
and also solve the issue of our GUI not packaged  on many OS.

The command line tools I am thinking about are these that are part of the
PostGIS code base and generally installable even on headless systems.
shp2pgsql (ESRI shape file loader) and pgsql2shp (ESRI shapefile dumper)

These could be set up in much the same way as how the Backup / Restore /
export/import (call pg_dump, pg_restore, psql)

This would require the user to have PostGIS command-line tools and PostGIS
in database installed to use it and the binaries in the PostgreSQL bin
folder.
For windows these files are always installed in PostgreSQL bin when PostGIS
is installed.  I think on Linux they are installed in system.

Do you see any issues with the idea I've outlined in Idea 2:

https://trac.osgeo.org/postgis/wiki/GoogleSummerCode2022

I haven't looked that closely at how those pieces in pgAdmin4 work so not
sure how difficult the task and if it makes sense for a GSOC project.

Thanks,
Regina




pgadmin-hackers by date:

Previous
From: Akshay Joshi
Date:
Subject: pgAdmin 4 commit: Update the release date in the release notes. Fixes #
Next
From: Dave Page
Date:
Subject: Re: PostGIS data loader / dumper - GSOC 2022 Idea