Re: How to add function schema in search_path in option definitio - Mailing list pgsql-general

From Lorusso Domenico
Subject Re: How to add function schema in search_path in option definitio
Date
Msg-id CAJMpnG5AnsPa6hBsz3g4V80rG1Abvt9CrZwN9QHGOpHavRo=BA@mail.gmail.com
Whole thread Raw
In response to Re: How to add function schema in search_path in option definitio  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: How to add function schema in search_path in option definitio
Re: How to add function schema in search_path in option definitio
Re: How to add function schema in search_path in option definitio
List pgsql-general
Hello Adrian,
I've created a schema to handle some specific features.
In the schema there are a couple of tables used by many functions (more than 20).
In other words, I've created a schema as a package (as suggested in many points).

I wish, in a function of this schema, to be able to call each other functions of this schema without adding the schema name in the call instruction.

For example:
in schema my_schema there are function foo and bar.

in foo I need to call bar:
foo as $$
begin
    [...]
    _returnOfBar=my_schema.bar(p1,p2,..,pn);
    [...]
end;
$$

I'd like to use just _returnOfBar=bar(p1,p2,..,pn);









Il giorno sab 8 lug 2023 alle ore 17:46 Adrian Klaver <adrian.klaver@aklaver.com> ha scritto:
On 7/8/23 08:06, Lorusso Domenico wrote:
> Hello guys,
> there is a comfortable way to add the schema of the function as in
> search path?
>
> something like
> create my_schema.function() as $body$...$body$
> set search_path to function_schema() || search_path

You can do something like:


show  search_path ;
    search_path
-----------------
  public, history


select set_config('search_path', 'test, ' ||
current_setting('search_path'), 'f');
       set_config
-----------------------
  test, public, history

show  search_path ;
       search_path
-----------------------
  test, public, history

>
> --
> Domenico L.
>
> per stupire mezz'ora basta un libro di storia,
> io cercai di imparare la Treccani a memoria... [F.d.A.]

--
Adrian Klaver
adrian.klaver@aklaver.com



--
Domenico L.

per stupire mezz'ora basta un libro di storia,
io cercai di imparare la Treccani a memoria... [F.d.A.]

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to add function schema in search_path in option definitio
Next
From: Adrian Klaver
Date:
Subject: Re: How to add function schema in search_path in option definitio