By David Crowther
How can you identify Distinct Values in a Column in PostGIS?
If you wish to identify the Distinct/Unique values in a column of data in a PostGIS table, use the following SQL statement in a Query Window:
- columnname – with the field in the PostGIS Table
- schema – with the schema in the database that the Table is stored
- tablename – with the table name
If you now Run the query all the Distinct Values in the defined column will be shown: