how to write stored procedure in postgresql code example
Example: postgresql procedure example
create [or replace] procedure procedure_name(parameter_list)
language plpgsql
as $$
declare
-- variable declaration
begin
-- stored procedure body
end; $$