Postgres Pro
Downloads
Home   >   mailing lists

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

From A. Kretschmer
Subject Re: Query to check existence of stored procedure?
Date
Msg-id 20060418141425.GE5964@webserv.wug-glas.de
Whole thread Raw
In response to Query to check existence of stored procedure?  (Alexander Scholz <alexander.scholz1@freenet.de>)
Responses Re: Query to check existence of stored procedure?
List pgsql-general
Tree view 
am  18.04.2006, um  8:26:49 +0200 mailte Alexander Scholz folgendes:
> Hi Newsgroup,
>
> I need a query which can check for the existence of a certain stored
> procedure.

proname in pg_proc.

select count(*) from pg_proc where proname = 'your_function';


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: "Nikolay Samokhvalov"
Date:
Subject: Re: Query to check existence of stored procedure?
Next
From: Tom Lane
Date:
Subject: Re: i have a core file on running gdb the op