Home > mailing lists

Re: How to use one function which can be accessed for all schemas - Mailing list pgsql-sql

From	David G. Johnston
Subject	Re: How to use one function which can be accessed for all schemas
Date	January 9 21:38:31
Msg-id	CAKFQuwbNC-34EG-nab6F=HNCdys_b0gW2J-NUf5V__iPAmJzBA@mail.gmail.com Whole thread Raw
In response to	Re: How to use one function which can be accessed for all schemas (Bindra Bambharoliya <bindra.bambharoliya@gmail.com>)
List	pgsql-sql

On Tue, Jan 9, 2024, 11:09 Bindra Bambharoliya <bindra.bambharoliya@gmail.com> wrote:

Create function in public or catalog schema. This function will be visible to each schema and user

Schemas don't have their own visibility, you should not create stuff in pg_catalog, and public is not guaranteed to be in the search_path.

And, please do not top-post replies.

David J.

From: Bindra Bambharoliya
Date: 09 January, 21:09:09
Subject: Re: How to use one function which can be accessed for all schemas

From: Samed YILDIRIM
Date: 31 January, 17:59:00
Subject: Re: Problem with refcursor