PostGIS – Distinct Values

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: