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.kla...@aklaver.com
