Postgresql Tutorials | what is procedure in postgresql | postgresql create procedure |call procedure

[@DindayalSahu-kc1tn]

Thanks a lot

[@Training2SQLMSBI]

thanks for your feedback

[@shashank2004]

Nice explanation, what the difference between procedure and function in postgresql? What's the advantage of procedure over function? When should be go for procedure or function

[@Training2SQLMSBI]

Thanks for your feedback ..
We have couple of differences .. will cover soon..

[@sandeepkongari5570]

Hi, can we return result set can you give example how to do in procedure.

[@seetaramy4956]

No it doesn't support. Go for a table valued function.

[@rahak123]

can we replace sq server stored procedure with Postgres procedure what is the dufference

[@spacewavematrix3009]

Please explain how to extract top 1 data with where clause from more than 3 different tables and store them in 3 different variables to generate xml or json out of it.

[@pallaviacharya5094]

I want to return 2 results from procedure is that possible

[@lakshmanm5289]

Hi I want basic postgresql store procedure how to create using XML file data insert into one master table. Please share me link with script.

[@cutaz1232]

I got an error syntax error at or near PROCEDURE

[@Training2SQLMSBI]

Whats the error message. Can you pls provide the full script as well.

[@cutaz1232]

@@Training2SQLMSBI CREATE PROCEDURE proc_selection ()
language 'plpgsql'
as $$
begin
select * from my_table;
end;
$$;