Re: Postgres Equivalent of Oracle Package

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: DAVID ROTH <adaptron(at)comcast(dot)net>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres Equivalent of Oracle Package
Date: 2021-11-16 17:27:02
Message-ID: CAFj8pRARkrmQCJyhX7762EkvVxxBHFT0RT6typBaAHBHmyNh-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DAVID ROTH 2021-11-16 19:51:36 Re: Postgres Equivalent of Oracle Package
Previous Message DAVID ROTH 2021-11-16 17:23:13 Postgres Equivalent of Oracle Package