From: Alvaro Herrera <alvherre@commandprompt.com>
To: Saii <saiisia@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Source of User Defined functions.
Date: Tue, 9 Sep 2008 18:04:21 -0400
Message-ID: <20080909220421.GG4223@alvh.no-ip.org> (raw)
In-Reply-To: <a4213bce0809091349k4f4c8c68ic2d05d3792e443d9@mail.gmail.com>
References: <a4213bce0809091349k4f4c8c68ic2d05d3792e443d9@mail.gmail.com>
Saii escribió:
> Hello,
>
> I have a questions regarding the location of source code of user defined
> functions in Postgres. I used the following query to get all function names
> but I
> do not see the source code of the user defined functions. In the 'prosrc'
> column, data is available for trigger functions only. Is there any other
> table/column where function source code can be found?
prosrc is source for all plpgsql functions (and others). If you have C
functions, you cannot see the code because all we know is a shared
library to load and function name to call.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, saiisia@gmail.com
Subject: Re: Source of User Defined functions.
In-Reply-To: <20080909220421.GG4223@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox