Re: How to use one function which can be accessed for all schemas

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Bindra Bambharoliya <bindra(dot)bambharoliya(at)gmail(dot)com>
Cc: "Wetmore, Matthew (CTR)" <Matthew(dot)Wetmore(at)express-scripts(dot)com>, intmail01 <intmail01(at)gmail(dot)com>, pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: How to use one function which can be accessed for all schemas
Date: 2024-01-09 18:38:31
Message-ID: CAKFQuwbNC-34EG-nab6F=HNCdys_b0gW2J-NUf5V__iPAmJzBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jan 9, 2024, 11:09 Bindra Bambharoliya <
bindra(dot)bambharoliya(at)gmail(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Samed YILDIRIM 2024-01-31 14:59:00 Re: Problem with refcursor
Previous Message Bindra Bambharoliya 2024-01-09 18:09:09 Re: How to use one function which can be accessed for all schemas