[Qgis-user] QGIS-Server How to avoid unique data check in postgis for each session

Jürgen E. Fischer jef at norbit.de
Wed Nov 16 06:00:20 PST 2022


Hi Amedeo,

On Wed, 16. Nov 2022 at 14:18:57 +0100, Amedeo Fadini via Qgis-user wrote:
> SELECT count(distinct ("id","field1"))=count(("id","field1")) FROM
> "public"."mytable"

Check  "use estimated table metadata" in the connection before adding the
layer.


Jürgen


-- 
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden            https://www.norbit.de
QGIS release manager (PSC)  Germany                 IRC: jef on Libera|OFTC
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221116/c8d4f0b4/attachment.sig>


More information about the Qgis-user mailing list