Why Auto Increment Is A Terrible Idea
The role of a primary key is to provide a stable, indexable reference to an entity. You have two ways to construct your primary key: either as a semantic key, or as a technical key.
.. PostgreSQL supports UUIDs, through the type
uuid.> select '697dffc9-8ba5-410c-b677-227475a73530'::uuid; uuid -------------------------------------- 697dffc9-8ba5-410c-b677-227475a73530 (1 row)