Re: stored procedures (packages) - Mailing list pgsql-general

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