[GENERAL] Function exists

2001-09-25 Thread Mihai Gheorghiu
I want to write a function that finds out whether a function already exists. Is that possible? How? Thank you all. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [GENERAL] Function exists

2001-09-25 Thread Marko Kreen
On Tue, Sep 25, 2001 at 02:20:23PM -0400, Mihai Gheorghiu wrote: I want to write a function that finds out whether a function already exists. Is that possible? How? select * from pg_proc where proname = ??; you can run psql with switch -E, then it shows intenal queries it performs. Eg., for