When I create a view in PostGIS is there any way to add a unique ID to that view? Just like the "gid" field in any other PostGIS table?
Edit: Sorry I should have included this in the original post. I am using PostGresql 9.0 and PostGIS 1.5.
You should be able to use the row_number() function as a column in your view. This works for Postgres 8.4 or higher.
This should work in most databases including SQL Server, Oracle, and MySQL.
For older versions of PostgreSQL (<= 8.3), here is another solution. In this example, I use another column name
First, create a sequence. Use
Now, create a VIEW that uses the sequence: