Re: Query to check existence of stored procedure?

From: Alexander Scholz <alexander(dot)scholz1(at)freenet(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query to check existence of stored procedure?
Date: 2006-04-18 15:08:50
Message-ID: e22vd0$1t3l$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark 2006-04-18 15:18:49 Using pg_dump and pg_restore
Previous Message Jim Buttafuoco 2006-04-18 14:44:35 Re: Query to check existence of stored procedure?