Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to preview functions code on pgAdmin 4?

When I would login into a postgresql database in pgAdmin3 and when I expand a schema I would see a tab for functions. When you click on the functions and select a function you can see the function's code.In pgAdmin 4 I don't see the tab for functions under schema. How can I see the function code in pgAdmin 4?

like image 342
user2631587 Avatar asked Apr 13 '26 13:04

user2631587


2 Answers

Click on the function and go to the Properties tab:

enter image description here

like image 82
Jim Jones Avatar answered Apr 18 '26 12:04

Jim Jones


In the version 2.x of pgAdmin4 when you connect to a GreenPlum database you will not be able to see Functions/External Tables/Graphical Explain Plans.

We are working with the pgAdmin4 community in order to introduce them in the next release.

Our hope is that in the next couple of weeks the version 3.0 will be released, with it you will be able to see Functions, you will be able to execute Explain and Explain Analyze plans. As we speak we are implementing the External Table part, that we hope will be finalized before 3.0 is released.

like image 39
jpereira Avatar answered Apr 18 '26 12:04

jpereira



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!