pgweb icon indicating copy to clipboard operation
pgweb copied to clipboard

List of functions in the left control panel alongside Tables, Views, etc

Open maksm90 opened this issue 8 years ago • 3 comments

Hi!

Now it's impossible to see the list of functions (stored procedures) belonging to the scheme. In perspective I would like not only to see the body of function but to store its updated version (CREATE OR REPLACE FUNCTION query)

maksm90 avatar Jul 07 '17 11:07 maksm90

List of functions could be added, but i'm not sure about function editor. You can always use custom sql query tab for that. Pgweb does not really have any way to modify any database stuff (except for the query tab) at the moment.

sosedoff avatar Jul 07 '17 14:07 sosedoff

List of functions could be added, but i'm not sure about function editor. You can always use custom sql query tab for that

Yes, sql query tab is intended for editing any queries including function body. But it would be nice to see the list of functions on left panel and have some tabs describing properties of selected function.

maksm90 avatar Jul 07 '17 15:07 maksm90

it would be really nice to atleast see function / procedure on the left panel and on selection show readonly code in structure tab.

A button to transfer the content as an alter / drop create statement to the editor tab will be icing on cake :)

suryapratap avatar Jul 23 '22 13:07 suryapratap

Implemented in #608, with read-only capability. Dont think its a good idea to allow users to edit functions as none of pgweb's functionality allows any edits.

sosedoff avatar Dec 07 '22 03:12 sosedoff