[Qgis-user] QGIS 2.10.1 adding PostGIS Views

Jürgen E. Fischer jef at norbit.de
Thu Sep 3 23:51:44 PDT 2015


Hi Andrea,

On Fri, 04. Sep 2015 at 08:42:31 +0200, Andrea Peri wrote:
> How do qgis to analyze the table to retrieve the unique?
> A loop on every record or a SQL to count distinct ?

For vies probably yes.  And if that doesn't help, any combination of fields (up
to all fields).  And then hope that the very expensively found "key constraint"
is not ruined by data added later.

But actual constraints can be retrieved from the database.


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             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150904/66e477d2/attachment.sig>


More information about the Qgis-user mailing list