Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexander Scholz
Subject Query to check existence of stored procedure?
Date
Msg-id e220qb$1gss$1@news.hub.org
Whole thread Raw
Responses Re: Query to check existence of stored procedure?  ("Nikolay Samokhvalov" <samokhvalov@gmail.com>)
Re: Query to check existence of stored procedure?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Query to check existence of stored procedure?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuuming of indexes on tables.
Next
From: jayati.biswas@cmcltd.com
Date:
Subject: recovery with pg_xlog