How to call postgresql procedure with output parameter


In a SQL query connecting to postgres 14, is there an example of syntax or steps to call a procedure that has output parameter in Retool? How would you declare and pass in the output variable?

Hi @sprinkle,
I don't know of an example, but I'm happy to hunt one down if you can share with me more about your use case. I'm not familiar with an output variable. Is that akin to this FUNCTION hello_world() seen on this blog? Do you have any attempts you've tried in Retool so far that would show me more about what you are trying to do?