Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject Re: Postgres Equivalent of Oracle Package
Date
Msg-id CAFj8pRARkrmQCJyhX7762EkvVxxBHFT0RT6typBaAHBHmyNh-g@mail.gmail.com
Whole thread Raw
In response to Postgres Equivalent of Oracle Package  (DAVID ROTH <adaptron@comcast.net>)
Responses Re: Postgres Equivalent of Oracle Package
List pgsql-general
Tree view
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: DAVID ROTH
Date:
Subject: Postgres Equivalent of Oracle Package
Next
From: DAVID ROTH
Date:
Subject: Re: Postgres Equivalent of Oracle Package