By David Crowther
Question:
How can you identify Distinct Values in a Column in PostGIS?
Answer:
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:
Simply replace:
- 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: