cmd to list functions

[djam]

hi, what is the cmd to list all the functions that I have? and also to view what the actual function is?

thanks " ahhh computers, how they made our lives much simpler "

 

[rosenk]

[tt]\df[/tt] in psql will show you all the functions, including system functions.

You can select from the [tt]pg_proc[/tt] system table to get more information about functions, including source.

[tt]SELECT prosrc FROM pg_proc WHERE proname='myfunction';[/tt]

 

[newbiepg]

if you are using the console

type \?
that will list you all the options for functions,tables,views etc

otherwise try phpPgAdmin
they will give you a big link from where you can view functions