X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 42495476197 for ; Sat, 22 Feb 2003 03:25:55 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 87126-05 for ; Sat, 22 Feb 2003 03:25:44 -0500 (EST) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 057B1476357 for ; Sat, 22 Feb 2003 01:13:22 -0500 (EST) Received: (qmail 2881 invoked from network); 22 Feb 2003 06:11:31 -0000 Received: from unknown (HELO system67.trade-india-local.com) (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 22 Feb 2003 06:11:31 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: Peter Eisentraut Subject: Re: function defination help .. Date: Sat, 22 Feb 2003 11:43:36 +0530 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200302221143.36565.mallah@trade-india.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/498 X-Sequence-Number: 11896 Thank you i will look into its source code. and try to find some solution for myself. regds mallah. On Saturday 22 February 2003 07:40 am, Peter Eisentraut wrote: > Rajesh Kumar Mallah writes: > > is it possible to get the function creation defination as produced by > > pg_dump by some SQL queries on system catalogs? > > > > pg_func stores procsrc but i am trying to get RETURNS and the arg part > > also. > > You will need to reconstruct what pg_dump does. -- Regds Mallah ---------------------------------------- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.