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. While you provide no context I would recommend that you consider avoiding OUT parameters and instead move them into the "RETURNS" clause. Furthermore I would probably define a "CREATE TYPE" and use that in the function declaration. If you have more than maybe 5-10 IN parameters I'd probably convert those into a TYPE as well. If you are working with table data each table implicitly is has a type defined for it that you can reference as well. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/New-line-for-stored-procedure-parameters-tp5814257p5814259.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
