Source of User Defined functions.

From: Saii <saiisia(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Source of User Defined functions.
Date: 2008-09-09 20:49:40
Message-ID: a4213bce0809091349k4f4c8c68ic2d05d3792e443d9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

SELECT p.proname, p.pronargs, t.typname,p.proowner, p.prosrc
FROM pg_proc p, pg_language l, pg_type t
WHERE p.prolang = l.oid
and p.prorettype = t.oid
and l.lanname in ('sql', 'plpgsql' )
and proowner = 964227
ORDER BY proname;

Thanks much
Saii

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Markova, Nina 2008-09-09 20:54:12 FW: How to upload data to postgres
Previous Message Kasia Tuszynska 2008-09-08 20:31:18 moving tablespaces on windows - is it possible?