Re: Query to check existence of stored procedure?

["A. Kretschmer" <andreas.kretschmer@xxxxxxxxxxxxxx>]

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    ===