> I have only used UUID and postgis.

If you used "uuid-ossp" to get uuid_generate_v4(), then this is no longer necessary since Postgres 13 as there is now a built-in gen_random_uuid()

https://www.postgresql.org/docs/current/functions-uuid.html