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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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.


View this message in context:
Sent from the PostgreSQL - novice mailing list archive at


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-2017 The PostgreSQL Global Development Group