CODEWITHSUNDEEP
postgresqlguid
NehaS
NehaS

Reputation: 23

Generate UUID/GUID in Postgres 12.8

I have the following postgres version, its an AWS Aurora Postgres -

"PostgreSQL 12.8 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit"

Is it possible to generate a GUID/UUID in this version ?

Upvotes: 0

Views: 409

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 126971

Yes, just install (activate) the extension pgcrypto and you can use the function gen_random_uuid() to create a version 4 UUID.

Upvotes: 1

Related Questions