Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Equivalent of Oracle Package - Mailing list pgsql-general

From DAVID ROTH
Subject Re: Postgres Equivalent of Oracle Package
Date
Msg-id 578672982.410788.1637092296124@connect.xfinity.com
Whole thread Raw
In response to Re: Postgres Equivalent of Oracle Package  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Postgres Equivalent of Oracle Package  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Postgres Equivalent of Oracle Package
Next
From: "Joe Wildish"
Date:
Subject: Plans with bad estimates/paths