On 09/30/11 12:57 AM, J.V. wrote:
I need to run a series of stored procedures, what is the best way to
organize and run.
Ideally would like something like Oracle PL/SQL where I can put all
methods in one file and create a main() method
then just : select main() to have them all run.
in function main, have
select function1();
select function2();
...
Also is it possible to call a stored function or procedure from
another stored proc/function?
see above.
note that postgres doesn't acctually have stored procedures, it only has
functions.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
