Re: [SQL] How to find SQL Functions

"Ross J. Reedstrom" <reedstrm(at)rice(dot)edu> writes:
> \df [optional function name glob]
> (there are, of course, equivalent SQL statements, that do the same thing
> as the above psql convienience functions, using the appropriate system
> tables (pg_*), which would allow one to avoid files and grep. But for
> learning, there's a catch-22, and I already knew how to use grep ;-)

BTW, 6.5 psql has a new command-line switch option -E, which causes it
to display the SQL statements that it issues to carry out special
commands like \df. Makes a great learning tool when you want to see
what the system tables contain.

regards, tom lane