Re: Source of User Defined functions.

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Saii <saiisia(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Source of User Defined functions.
Date: 2008-09-09 22:04:21
Message-ID: 20080909220421.GG4223@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Klaver 2008-09-10 02:43:13 Re: FW: How to upload data to postgres
Previous Message Markova, Nina 2008-09-09 20:54:12 FW: How to upload data to postgres