get source of udf

From: Peter Kroon <plakroon(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: get source of udf
Date: 2012-11-20 00:29:48
Message-ID: CAOh+DOnokUzvuuO1x8byaSPFcbFihOuy=Ag0HFd1=Uts_MNGpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

I would like to get the source of a udf.
In mssql I run this query:
SELECT OBJECT_DEFINITION(OBJECT_ID) FROM sys.objects WHERE
name='function_name';
And I get the entire source of the function.

How must I do this in PostgreSQL?

Thanks,
Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message JulAkmad, Julpikar 2012-11-20 00:51:13 Re: [SOLVED] WINDOWS : PostgreSQL 8.4 Server Start Error
Previous Message John R Pierce 2012-11-19 23:40:18 Re: Experiences with pl/Java