Postgres Pro
Downloads
Home   >   mailing lists

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

From Lorusso Domenico
Subject How to add function schema in search_path in option definitio
Date
Msg-id CAJMpnG7LqoS5=2derJ3UmL1UGw859RtjZ1buM1EMa+CL+8mjfQ@mail.gmail.com
Whole thread Raw
Responses Re: How to add function schema in search_path in option definitio  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: How to add function schema in search_path in option definitio  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

--
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: Ben Chobot
Date:
Subject: Re: pgbouncer best practices
Next
From: Adrian Klaver
Date:
Subject: Re: How to add function schema in search_path in option definitio