Is there any chance to have duplicate hexadecimal value while migrating oracle to Postgres (guid to UUID)
I have a table having column which is generate 32 character hexadecimal value by using sys_guid function (default oracle sys object). Now I want to migrate Oracle to Postgres but guid is not supported by Postgres but it has UUID instead of guid. Just want to confirm that whether there will be any chance to have duplicate value after migrating oracle to Postgres
GUID is a synonym for UUID.
The UUIDs generated by Oracle can be stored without problems in a column defined as uuid in Postgres.
Postgres provides gen_random_uuid() that will generate a V4 UUID.