Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 25B2B475CE0 for ; Tue, 9 Jul 2002 13:44:01 -0400 (EDT) Mailbox-Line: From achill@matrix.gatewaynet.com Tue Jul 9 13:44:01 2002 Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id 68B83476124 for ; Tue, 9 Jul 2002 10:31:24 -0400 (EDT) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id g69EUTQ18936; Tue, 9 Jul 2002 17:30:29 +0300 Date: Tue, 9 Jul 2002 17:30:29 +0300 (EEST) From: Achilleus Mantzios To: Joseph Syjuco Cc: postgres Subject: Re: export plpgsql function to file In-Reply-To: <1026238009.7136.3.camel@Askr> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Status: No, hits=-3.5 required=5.0 tests=IN_REP_TO,X_NOT_PRESENT,NO_MX_FOR_FROM version=2.30 X-Spam-Level: X-Archive-Number: 200207/119 X-Sequence-Number: 8498 On 9 Jul 2002, Joseph Syjuco wrote: select prosrc from pg_proc where proname='foofunc'; The other way is dumping the database and extracting afterwards only the create statement of your function > how can i export my postgresql function to a file? > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr