2014-08-08 23:19 GMT+02:00 David G Johnston <david.g.johns...@gmail.com>:
> inspector morse wrote > > 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. -- Guillaume. http://blog.guillaume.lelarge.info http://www.dalibo.com
