Re: Postgres Equivalent of Oracle Package

On 11/16/21 12:23, DAVID ROTH wrote: One of the nice things about Oracle packages is that the code is loaded and global values are set and stored only once per session. This is very useful for values that are used repeatedly. What is the best way of emulating this behavior in Postgresql?

Re: Postgres Equivalent of Oracle Package

Hi út 16. 11. 2021 v 20:51 odesílatel DAVID ROTH napsal: > I can see how schemas can be used to keep related tables and other object > together. I may be missing something but I don't see how they can be used > to emulate the "once-per-session" behavior of Oracle packages. Have I > missed somet

Re: Postgres Equivalent of Oracle Package

I can see how schemas can be used to keep related tables and other object together. I may be missing something but I don't see how they can be used to emulate the "once-per-session" behavior of Oracle packages. Have I missed something? > On 11/16/2021 12:27 PM Pavel Stehule wrote: > > >

Re: Postgres Equivalent of Oracle Package

Hi út 16. 11. 2021 v 18:23 odesílatel DAVID ROTH napsal: > One of the nice things about Oracle packages is that the code is loaded > and global values are set and stored only once per session. This is very > useful for values that are used repeatedly. > > What is the best way of emulating this b

Postgres Equivalent of Oracle Package

One of the nice things about Oracle packages is that the code is loaded and global values are set and stored only once per session. This is very useful for values that are used repeatedly. What is the best way of emulating this behavior in Postgresql?