Re: Package-support plans? - Mailing list pgsql-general

Nicklas Karlsson schrieb am 20.11.2018 um 07:32:
> Are there any plans for including Oracle-style packages with
> namespace/visibility support at some point or is it just "use
> schemas"? I could even live without package-state but I find it
> frustrating with the namespace pollution when the application grows.
>

If you don't need package-level variables, you could use schemas put functions in different namespaces.

  create schema package_one;
  create function package_one.function_one() as ...;

  create schema package_two;
  create function package_two.function_two() as ...;