Thread: Can you list the text of a proc in psql?

Can you list the text of a proc in psql?

From
adb
Date:
Is there anyway to do the equivalent of sp_helptext in sybase
which would allow you to see the source code for a proc in the
server.  This is useful sometimes in determining which
version of a proc you have loaded in the server or in
figuring out exactly what some proc does that you didn't write.

Thanks,

Alex.


Re: Can you list the text of a proc in psql?

From
Peter Eisentraut
Date:
adb writes:

> Is there anyway to do the equivalent of sp_helptext in sybase
> which would allow you to see the source code for a proc in the
> server.  This is useful sometimes in determining which
> version of a proc you have loaded in the server or in
> figuring out exactly what some proc does that you didn't write.

\df+ [function-name]

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/