[ADMIN] OID for pg_get_functiondef

2011-05-02 Thread jtkells
I've just started working on an 8.4 database and I have been asked to extract all the functions source code stored in various databases and schemas so they can be put into a repository for the developers. I'm planning to use pg_get_functiondef(OID) but I am having a hard time finding the OID

Re: [ADMIN] OID for pg_get_functiondef

2011-05-02 Thread Raghavendra
select oid,proname from pg_proc where proname='function-name'; Best Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Mon, May 2, 2011 at 10:22 PM, jtke...@verizon.net wrote: I've just started working on an 8.4 database and I have been asked to extract all

Re: [ADMIN] OID for pg_get_functiondef

2011-05-02 Thread Thomas Kellerer
jtke...@verizon.net wrote on 02.05.2011 18:52: I've just started working on an 8.4 database and I have been asked to extract all the functions source code stored in various databases and schemas so they can be put into a repository for the developers. I'm planning to use

Re: [ADMIN] OID for pg_get_functiondef

2011-05-02 Thread Raghavendra
On Mon, May 2, 2011 at 10:53 PM, Thomas Kellerer spam_ea...@gmx.net wrote: jtke...@verizon.net wrote on 02.05.2011 18:52: I've just started working on an 8.4 database and I have been asked to extract all the functions source code stored in various databases and schemas so they can be put