[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