Postgresql install plpython3u

Question

Hello,

With amazon we can't use plpython3u extension in our postgresql database. Is it possible with azure postgresql databases ? I can't find this information on the documentation.

Thank you !

Answer 1

Hi @Valentin GARREAU Welcome to the Microsoft Q&A platform, thanks for posting the question
As I understand you want to know if the plpython3u extension can be used in PostgreSQL databases.
All the supported extensions can be found under Portal > Azure Database for PostgreSQL > [your server name] > Server Parameters > Parameter name = azure.extensions
please refer to the documentation here
I don’t see that extension listed as an option, and I don’t believe it’s possible to add extensions that are not on the list.

I hope this information helps, let me know if you have any additional questions.

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

To install PL/Python in a particular database, use CREATE EXTENSION plpythonu (but see also Section 45.1).