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	July 8, 2023 18:06:29
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 Re: How to add function schema in search_path in option definitio
List	pgsql-general

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.]

From: Ben Chobot
Date: 08 July 2023, 16:46:37
Subject: Re: pgbouncer best practices

From: Adrian Klaver
Date: 08 July 2023, 18:31:25
Subject: Re: How to add function schema in search_path in option definitio