From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Sasmit Utkarsh <utkarshsasmit(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Need Assistance: Command to display procedures does not work |
Date: | 2024-02-28 17:20:40 |
Message-ID: | ceb2515d-5016-44dd-923a-dcb83413d286@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2/28/24 09:13, Sasmit Utkarsh wrote:
Reply to list also
Ccing list
> HI Adrian,
>
> Related to shc shema, they were part of different host/machine.
> Currently, I'm seeing the result for this discrepancy on another server
> machine where we have only a public schema.
1) I doubt that if this is the database you are showing in your pgAdmin4
screenshot.
2) The information I asked for in my previous post is still relevant and
needs answering.
3) Add pronamespace::regnamespace to your SELECT query to get the schema
names for the the functions.
>
>
> Regards,
> Sasmit Utkarsh
> +91-7674022625
>
>
> On Wed, Feb 28, 2024 at 10:35 PM Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> On 2/28/24 08:52, Sasmit Utkarsh wrote:
> > Hi Adrian,
> >
> > Thanks for the info, But I have another question: I could see the
> below
> > functions list with the help on query execution on psql command line
> >
> > shc_data=> S*ELECT proname AS function_name,proacl AS
> privileges FROM
> > pg_proc WHERE proname in
> >
> ('sql_insert_data_procedure','sql_select_data_procedure','sql_select_size_procedure','sql_update_data_procedure');*
> > function_name | privileges
> > ---------------------------+------------
> > sql_select_size_procedure |
> > sql_select_data_procedure |
> > sql_insert_data_procedure |
> > sql_update_data_procedure |
> > (4 rows)
> >
> > but when I try to connect to the same db on PgAdmin4, I don't see
> the
> > list even after refresh. Why is that different?
>
> 1) Are you sure you are connecting to correct database.
>
> 2) If I followed your previous posts correctly those functions where
> not
> in the public schema you are looking at in pgAdmin4. They where in the
> shc(?) schema which I am pretty sure is the second schema in the
> Schemas(2) in the object tree.
>
>
> > Thet
> > image.png
> >
> >
> >
> >
> >
> > Regards,
> > Sasmit Utkarsh
> > +91-7674022625
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dominique Devienne | 2024-02-28 17:38:44 | Re: Non-Stored Generated Columns |
Previous Message | Sasmit Utkarsh | 2024-02-28 17:19:42 | Re: Need Assistance: Command to display procedures does not work |