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