Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6FC561337990 for ; Mon, 2 May 2011 14:08:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 85734-04 for ; Mon, 2 May 2011 17:07:54 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 1D6A513364DE for ; Mon, 2 May 2011 14:07:54 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id p42H7rn6091827 for ; Mon, 2 May 2011 14:07:53 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id p42GqnMs062018 for pgsql-admin@postgresql.org; Mon, 2 May 2011 13:52:49 -0300 (ADT) (envelope-from news) From: jtkells@verizon.net X-Newsgroups: pgsql.admin Subject: OID for pg_get_functiondef Message-ID: <5sntr656p8qf7se8s74m80330kaoogs93a@4ax.com> X-Newsreader: Forte Agent 6.00/32.1186 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 11 X-Complaints-To: abuse@easynews.com Organization: Forte Inc. http://www.forteinc.com/apn/ X-Complaints-Info: Please be sure to forward a copy of ALL headers otherwise we will be unable to process your complaint properly. Date: Mon, 02 May 2011 12:52:35 -0400 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_40=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201105/9 X-Sequence-Number: 37446 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 for functions. I've looked into the information_schema and the pg_catalog schemas and have found information on functions but none of them seem to have the OID of the function. Can anyone please tell how to get the OID for a function within a schema and or if there is a better way. Thanks