Sometimes we want to have native support for UUID’s in Postgres, fortunately there is already a ready-made extension that makes it easy.
Enter the “uuid-ossp” extension… fortunately furthermore, its very easy to use…
- Enable the extension:
CREATE EXTENSION IF NOT EXISTS “uuid-ossp”
- Set default value on the column to “expression” and use the following default value: