postgresql - use store procedure and function in java

Question

Hi all,
I wanted to know how can I use store procedure and function written in java in PostgreSQL service on azure?
As for now Azure PostgreSQL doesn't support Pl/Java extension.
thanks!

Answer 1

Hi, @Miriam Orzitzer Welcome to the Microsoft Q&A forum, Thanks for posting your question and using Azure services.
As we understand the ask here is you want to know how to use store procedures and functions written in java for the Azure PostgreSQL service.
Yes you are right unfortunately we do not support these extensions.I think this due to the natural of PaaS service and the capabilities of java extension itself.
Here are the supported extensions by Azure PostgreSQL
Please let me know if you need more information.

Regards
Geetha

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer.

Answer 2

You can look at this Calling Stored Functions and Procedures