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 <pavel.steh...@gmail.com> wrote: > > > Hi > > Ășt 16. 11. 2021 v 18:23 odesĂlatel DAVID ROTH <adapt...@comcast.net > mailto:adapt...@comcast.net > 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 behavior in Postgresql? > > > > > > you can use a schemas - you can see it in Orafce > > https://github.com/orafce/orafce > > Regards > > Pavel > >