Re: How to view the functions that exists

I am using 7.1.2
\d pg_proc
and submit some query: select * from pg_proc where ...

Antoine Reid wrote:

> On Fri, Nov 09, 2001 at 04:21:57PM +0000, qradius@qnet.com.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>