Re: Packages? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Packages?
Date
Msg-id CAFj8pRConRCxWX4qyEMb+HMN=RpC2zvg802QCHornd7PYs_18g@mail.gmail.com
Whole thread Raw
In response to Packages?  (Post Gresql <postgresql@taljaren.se>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Post Gresql
Date:
Subject: Packages?
Next
From: Mario Emmenlauer
Date:
Subject: Re: Is it possible to write a generic UPSERT?