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

Paolo Cavallini cavallini at faunalia.it
Fri Oct 9 07:55:25 PDT 2020


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);
...

Why it is not using the modern syntax, with standard geom name

geom GEOMETRY(LineString, 4326));
?

All the best.
-- 
Paolo Cavallini
www.faunalia.eu - QGIS.org
training, support, development on QGIS, PostGIS and more


More information about the QGIS-Developer mailing list