From: | Jan Poslusny <pajout(at)gingerall(dot)cz> |
---|---|
To: | Antoine Reid <antoiner(at)hansonpublications(dot)com> |
Cc: | qradius(at)qnet(dot)com(dot)pe, pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to view the functions that exists |
Date: | 2001-11-10 10:06:18 |
Message-ID: | 3BECFC1A.4040004@gingerall.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jo | 2001-11-10 10:29:36 | inheritance and foreign keys |
Previous Message | Micah Yoder | 2001-11-10 05:07:25 | Re: Storing a tree |