Postgres sql return uuid after insert into table?

Question

I am doing insert into one table record and generating UUID, how do I return this UUID to use in another part of my function?

function

do $$
begin 
 insert into table_1 values (uuid,,,,,,n);

-- need the result of this insert load into variable uuid_customer to reuse later

insert into tabel_2 (uuid,uuid_customer,,,,,,n );
end

in MSSQL I can use output, but what about Postgres

INSERT INTO table (name) OUTPUT Inserted.ID VALUES('bob');

Edouard · Accepted Answer · 2022-01-23 20:15:51Z

1

Try this :

WITH list AS
( insert into table_1 
  values (uuid,,,,,,n)
  returning uuid
)
SELECT uuid INTO uuid_customer ;

answered Jan 23, 2022 at 20:15

Edouard

7,1291 gold badge11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres sql return uuid after insert into table?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related