Re: Query to check existence of stored procedure? - Mailing list pgsql-general

From Alexander Scholz
Subject Re: Query to check existence of stored procedure?
Date
Msg-id e22vd0$1t3l$1@news.hub.org
Whole thread Raw
In response to Re: Query to check existence of stored procedure?  ("Jim Buttafuoco" <jim@contactbda.com>)
Responses Re: Query to check existence of stored procedure?  ("Jim Buttafuoco" <jim@contactbda.com>)
List pgsql-general
Hi Jim,

>> select count(*) from pg_proc where proname = 'your_function';
>>
> don't forget about schema's, you will need to join with
> pg_namespace.oid and pg_proc.pronamespace

your answer looks a little bit cryptic for me being somebody who hasn't
had to dive into the pg_... tables yet. :-)

What do you exactly mean? Could you provide me a complete query for that
job?

Is there anything to consider, if the user performing this query is NOT
the owner of the stored prodcedure? (but he needs this info as well!)

Thank you in advance,

Alexander.


pgsql-general by date:

Previous
From: sconeek@gmail.com
Date:
Subject: deleting table content through command prompt
Next
From: jayati.biswas@cmcltd.com
Date:
Subject: recovery problem