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. > > If there is a way to do this, please let me know.
Don't try to do PostgreSQL things the Oracle way. To group functions that logically belong together, you can put them into a separate schema. You can grant users execute rights on only one of them if you like (or rather, because by default PUBLIC has execute rights, revoke that from all others). > Also is it possible to call a stored function or procedure from another > stored proc/function? Sure, use them in an SQL statement inside a function. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
