I am trying to with a select statement generate a unique guid for each row. I tried this but the guid is the same so don't have this correct yet.

select * from tblCustomer, (select gen_random_uuid() as newId)

I am trying to with a select statement generate a unique guid for each row. I tried this but the guid is the same so don't have this correct yet.

select * from tblCustomer, (select gen_random_uuid() as newId)

• postgresql

• Is this guid based on the row's content, or just a unique random ID? gen_random_uuid is a uuid v4, also exists the serials and something like "select md5(f::text) FROM f" – Frank N Stein Commented Mar 17 at 17:16
• Why do you even use a subquery for this? – Frank Heikens Commented Mar 17 at 17:44

1 Answer 1

This is happening because you're generating newId in a subquery; there's no reason to do this.

Here's what you want instead:

SELECT *,
       gen_random_uuid() AS newId
  FROM tblCustomer;

I've spread it over three lines here to clearly delineate how the query is structured, but you can keep it on one line if you prefer.