Re: Oracle Package equivalent in Postgres

Поиск
Список
Период
Сортировка
От Holger Jakobs
Тема Re: Oracle Package equivalent in Postgres
Дата
Msg-id 807c8d86-ac4e-796e-f821-4a88279df6d3@jakobs.com
обсуждение исходный текст
Ответ на Oracle Package equivalent in Postgres  (Firthouse banu <penguinsfairy@gmail.com>)
Список pgsql-admin
Hi,

It depends on what you want to achieve with using packages.

If you just want to group a number of functions and procedures, just
create a schema for it (schemas are totally unrelated to users in
PostgreSQL), e. g.
CREATE SCHEMA functions;
and then
CREATE FUNCTION functions.f1 (integer) RETURNS integer LANGUAGE plgpsql
AS $$
...
$$;

Unfortunately, there are no schema related variables. You will have to
resort to saving values in some (temporary, unlogged, normal) table.

There is another way of using a setting as a variable described here:

https://dba.stackexchange.com/questions/165361/assign-the-result-of-current-settingthe-setting-to-a-variable-in-pl-pgsql/165372#165372

Regards,

Holger


Am 06.08.20 um 14:22 schrieb Firthouse banu:
> Hi Postgres master minds, 
>
> Am currently working on migrating databases from  oracle to Postgres. 
> Am going to work on crons and packages in oracle which needs to be
> converted in Postgres. How to convert package in oracle to Postgres.
> Is there any equivalent in Postgres if not how it works in Postgres. 
>
> Eagerly  waiting for replies. 
>
> Thanks 
>
-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012




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

Предыдущее
От: Firthouse banu
Дата:
Сообщение: Oracle Package equivalent in Postgres
Следующее
От: MichaelDBA
Дата:
Сообщение: Re: Oracle Package equivalent in Postgres