Re: Postgres Equivalent of Oracle Package

Поиск
Список
Период
Сортировка
От DAVID ROTH
Тема Re: Postgres Equivalent of Oracle Package
Дата
Msg-id 578672982.410788.1637092296124@connect.xfinity.com
обсуждение исходный текст
Ответ на Re: Postgres Equivalent of Oracle Package  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Postgres Equivalent of Oracle Package
Список pgsql-general
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.stehule@gmail.com> wrote:


Hi

út 16. 11. 2021 v 18:23 odesílatel DAVID ROTH <adaptron@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


Regards

Pavel

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Postgres Equivalent of Oracle Package
Следующее
От: "Joe Wildish"
Дата:
Сообщение: Plans with bad estimates/paths