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: Query to check existence of stored procedure?
Date: 2006-04-18 06:26:49
Message-ID: e220qb$1gss$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Newsgroup,

I need a query which can check for the existence of a certain stored
procedure.

(The pendant for MS SQL is

IF EXISTS (SELECT * FROM "sysobjects" WHERE "id" =
object_id(N'"MyTestStoredProcedure"') and OBJECTPROPERTY("id",
N'IsProcedure') = 1)
...
)

Any help would be appreciated! :-)

Thanx in advance,

Alexander.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2006-04-18 06:33:50 Re: Postgresql and Creator2 commitChanges()
Previous Message jayati.biswas 2006-04-18 06:10:42 recovery with pg_xlog