Skip site navigation (1) Skip section navigation (2)

Show stored function code

From: mephysto <mephystoonhell(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Show stored function code
Date: 2012-03-28 13:33:17
Message-ID: 1332941597167-5600485.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,
I'm trying to execute search in my stored functions code, but I have some
difficulties. I'm using postgres 9.1.3, and if I execeute this query

SELECT prosrc FROM pg_proc WHERE proname = <function name>;

I retrieve an empty column for all my custom stored functions.

Are I committing some errors?
Is there an alternative way to achieve my goal?

Thanks in advance.

Meph

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Show-stored-function-code-tp5600485p5600485.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

Responses

pgsql-novice by date

Next:From: mephystoDate: 2012-03-28 13:36:43
Subject: Re: application_name
Previous:From: JORGE MALDONADODate: 2012-03-28 13:28:13
Subject: Re: Restoring roles information

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group