Using geometry column as primary key

by Sujay Sanjeev Patil   Last Updated June 13, 2019 04:22 AM

I have a Postgresql/PostGIS table with me which stores data about all the warning signs around the world. The map data is provided to me by our vendor, and the data is such that no possible combination of columns from the table can be used to define a suitable primary key for the table.

My objective is to create a primary key and creating a new AUTO_INCREMENT-like column with plain integers is not going to cut it.

So my question is, since the only column with actually unique data is the geometry column provided to me, is there any way to use this data in order to develop/create a suitable primary key?

Thank you.



Related Questions


Updated October 30, 2018 14:22 PM

Updated October 04, 2018 22:22 PM

Updated June 20, 2015 01:09 AM

Updated March 25, 2018 18:22 PM

Updated January 17, 2018 00:22 AM