Hi út 16. 11. 2021 v 20:51 odesílatel DAVID ROTH <adapt...@comcast.net> 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 something? > There is nothing similar in Postgres. I am working session variables, that should be created in schema too. As workaround you can use GUC - configuration variables, that can be used for storing private values too. Regards Pavel > 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> > 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 > >