don't forget about schema's, you will need to join with pg_namespace.oid and pg_proc.pronamespace
---------- Original Message ----------- From: "A. Kretschmer" <[EMAIL PROTECTED]> 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 ------- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
