Re: Query to check existence of stored procedure?

don't forget about schema's, you will need to join with pg_namespace.oid and pg_proc.pronamespace

---------- Original Message -----------
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-general@postgresql.org
Sent: Tue, 18 Apr 2006 16:14:25 +0200
Subject: Re: [GENERAL] Query to check existence of stored procedure?

> 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    ===
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
------- End of Original Message -------