Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 656839FA5FE
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 27 Nov 2006 05:33:27 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024)
	with ESMTP id 43154-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 27 Nov 2006 05:33:16 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.189])
	by postgresql.org (Postfix) with ESMTP id 657B19FA23F
	for <pgsql-admin@postgresql.org>; Mon, 27 Nov 2006 05:33:19 -0400 (AST)
Received: by nf-out-0910.google.com with SMTP id x4so2238933nfb
	for <pgsql-admin@postgresql.org>; Mon, 27 Nov 2006 01:33:18 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=a/P/WvvOPbCWvu6P6U/dVKZnf3s5f5yEMxU0PU0L7pIR9hcR/774wAuzGIUFQnfJrsWP8UW6XugALirz6xbqE4LecpPAKorTm8OMqmVcmWZ4Uexb1+V7ACDO2CiJ5wM3G2sR0T+KCQ+geMxN/ws0hinl3ivkrUQwKYxr0F2Ju9Y=
Received: by 10.82.142.9 with SMTP id p9mr1934729bud.1164619997412;
	Mon, 27 Nov 2006 01:33:17 -0800 (PST)
Received: by 10.82.161.3 with HTTP; Mon, 27 Nov 2006 01:33:17 -0800 (PST)
Message-ID: <1f30b80c0611270133m189cc12qfe207c879dfe2802@mail.gmail.com>
Date: Mon, 27 Nov 2006 14:33:17 +0500
From: imad <immaad@gmail.com>
To: "Doron Baranes" <doron.baranes@dbnet.co.il>
Subject: Re: Functions
Cc: pgsql-admin@postgresql.org
In-Reply-To: <0BA77301DFF4B24C9C5DAA74138BF95003C783@exchange-1.dbnet.co.il>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <0BA77301DFF4B24C9C5DAA74138BF95003C783@exchange-1.dbnet.co.il>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/216
X-Sequence-Number: 23743

select prosrc from pg_proc where proname = '<function_name>';

However you cannot see the code of C language function with this query.

is that what you wanted?

--Imad
www.EnterpriseDB.com


On 11/27/06, Doron Baranes <doron.baranes@dbnet.co.il> wrote:
>
> Hi,
>
> I'm new to postgres and i cant find how can i get a function code from the database.
>
> 10x
> Doron
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>