UUID instead of GUID (Oracle to Postgres)

802 Views Asked by At

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

1

There are 1 best solutions below

2
AudioBubble On BEST ANSWER

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.