> I have a stored procedure with several input/output parameters (about 50 > of > them). Everytime I go to edit the stored procedure in pgAdmin3, it prints > all of the parameters in the same line...even if I last saved it with new > lines. This makes it really difficult to see the parameter list as I have > to scroll horizontally. > > Is there a setting I can set in pgAdmin3 so it keeps my formatting...or at > least prints each parameter in a new line instead of printing all of them > horizontally?
There is no way for it to know what you did last time - while the body of your function is stored as-is the various parts of the CREATE FUNCTION statement are parsed and stored into the database catalogs. pgAdmin then queries those catalogs and recreates - in a canonical form - the command.
It would be possible for pgAdmin to toggle between "all on one line" and "one line per parameter" but I am unsure if that is something it can currently do.
It cannot. And I'm not sure this is something we'd like to add.