Re: How to add function schema in search_path in option definitio

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