Re: How to view the functions that exists

On Fri, Nov 09, 2001 at 04:21:57PM +0000, qradius(at)qnet(dot)com(dot)pe wrote:
> Hi !
>
> I have a consulta about how Imcan view what are defined on my
> database, and their deinitions?

When using the command line interface, psql, you can issue:

\df <function>
where it will give you a list of all functions that begin with the supplied
argument. As an example, here, all developers name their functions with a
prefix of sp_ (this must be from using MS SQL..)

so: \df sp_ will give you a list of all functions.

If you want to see the source of the function, you can use

\df+ sp_function_name

and you get to see the source of all functions that begin with that pattern
(again).

> Thank you
>
> Ernesto

Hope that helps
Antoine