[PostGIS] #2935: shp2pgsql: There should be a way to add a delete table statement even when just preparing the DDL

PostGIS trac at osgeo.org
Sun Jun 21 06:06:05 PDT 2026


#2935: shp2pgsql: There should be a way to add a delete table statement even when
just preparing the DDL
----------------------------------+-----------------------------
  Reporter:  jimktrains           |      Owner:  pramsey
      Type:  enhancement          |     Status:  closed
  Priority:  medium               |  Milestone:  PostGIS Fund Me
 Component:  utils/loader-dumper  |    Version:  2.1.x
Resolution:  fixed                |   Keywords:  shp2pgsql
----------------------------------+-----------------------------
Changes (by Darafei Praliaskouski <me@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"37db33a47b8d380d6b58f8fcdf4824bfa0f2c847/git"
 37db33a4/git]:
 {{{#!CommitTicketReference repository="git"
 revision="37db33a47b8d380d6b58f8fcdf4824bfa0f2c847"
 loader: add shp2pgsql --drop-table option

 Add --drop-table to request a DROP TABLE IF EXISTS statement before
 create/prepare output without changing mutually exclusive load modes. Keep
 -d as the drop/create/load preset and reject --drop-table -a because
 append mode has no create step to precede.

 Closes #2935

 Closes https://github.com/postgis/postgis/pull/1048
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2935#comment:11>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list