Re: New line for stored procedure parameters?

2014-08-08 23:19 GMT+02:00 David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)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