[QGIS-Developer] Save as PG dump create obsolete dumps

[Nyall Dawson]

On Mon, 12 Oct 2020 at 16:55, Paolo Cavallini <cavallini at faunalia.it> wrote:
>
> Hi Nyall,
>
> Il 12/10/20 01:15, Nyall Dawson ha scritto:
> > On Sat, 10 Oct 2020 at 00:52, Paolo Cavallini <cavallini at faunalia.it> wrote:
> >>
> >> Hi all,
> >> this is what it is produced:
> >>
> >> SET standard_conforming_strings = OFF;
> >> DROP TABLE IF EXISTS "public"."test_export" CASCADE;
> >> DELETE FROM geometry_columns WHERE f_table_name = 'test_export' AND
> >> f_table_schema = 'public';
> >> BEGIN;
> >> CREATE TABLE "public"."test_export" ( "ogc_fid" SERIAL, CONSTRAINT
> >> "test_export_pk" PRIMARY KEY ("ogc_fid") );
> >> SELECT
> >> AddGeometryColumn('public','test_export','wkb_geometry',4326,'LINESTRING',2);
> >
> > Is this through the standard right click layer - export functionality?
> > If so, the SQL is being created by GDAL, not QGIS, so this should be
> > raised as a GDAL ticket.
>
> sorry I was unclear:
> this is done through the Browaser> Save as file. Is this one also using
> GDAL?

Yes, that is -- it's the exact same code as when you right click a
layer from a project.

Nyall

> Cheers.
>
> --
> Paolo Cavallini
> www.faunalia.eu - QGIS.org
> training, support, development on QGIS, PostGIS and more