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.kla...@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.kla...@aklaver.com > > -- Domenico L. per stupire mezz'ora basta un libro di storia, io cercai di imparare la Treccani a memoria... [F.d.A.]