Обсуждение: Packages?

Поиск
Список
Период
Сортировка

Packages?

От
Post Gresql
Дата:
Hi,

Is there chance we will get packages (like those in Oracle) in PostgreSQL?

They are kind of nice to have. The main advantage from my point of view 
is the ability to grant execute to a single package to a user and then 
they can run all procedures in the package.

Re: Packages?

От
Pavel Stehule
Дата:
Hi

pá 13. 11. 2020 v 8:29 odesílatel Post Gresql <postgresql@taljaren.se> napsal:
Hi,

Is there chance we will get packages (like those in Oracle) in PostgreSQL?

This probability is very low - Postgres has redundant feature - schema. Schema (in Postgres) can be used like Oracle's packages.  Orafce uses schemas instead packages well.


They are kind of nice to have. The main advantage from my point of view
is the ability to grant execute to a single package to a user and then
they can run all procedures in the package.

Without usage right nobody can use function or procedure from schema.

Regards

Pavel