Can you list the text of a proc in psql?

Started by adbabout 25 years ago2 messagesgeneral
Jump to latest
#1adb
adb@Beast.COM

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.

#2Peter Eisentraut
peter_e@gmx.net
In reply to: adb (#1)
Re: Can you list the text of a proc in psql?

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/