Postgres Equivalent of Oracle Package

From: DAVID ROTH <adaptron(at)comcast(dot)net>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Postgres Equivalent of Oracle Package
Date: 2021-11-16 17:23:13
Message-ID: 826773243.402693.1637083393436@connect.xfinity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2021-11-16 17:27:02 Re: Postgres Equivalent of Oracle Package
Previous Message Дмитрий Иванов 2021-11-16 16:57:38 Re: pg_restore depending on user functions