Re: List of Functions

On Thu, 21 Apr 2005, Dinesh Pandey wrote:

> \df
> \df functionname

also, \df function*

>
>
> Thanks
> Dinesh Pandey
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Rob Stone
> Sent: Thursday, April 21, 2005 9:48 AM
> To: 'pgsql-general@postgresql.org'
> Subject: [GENERAL] List of Functions
>
> I have no idea if this is the correct list to use.
>
> How do you obtain a list of the functions and their argument lists that have
> been created on a Postgres database?
>
> I have tried searching various lists and archives plus the documentation.
> All I want to find is a list of:-
>
> Function name        return value        arguments.
>
> After you run the "create or replace" script, this data has to be saved
> somewhere. Just the name of the table would do.
>
> Thanks,
> Robert Stone
>
> "CONFIDENTIALITY NOTICE AND DISCLAIMER - The information in this
> transmission may be confidential and/or protected by legal privilege, and is
> intended only for the person or persons to whom it is addressed. If you are
> NOT such a person, you are warned that any disclosure, copying or
> dissemination of the information is unauthorised.
> If you have received this transmission in error, please advise Park Lane
> Information Technology --  +61 (03) 9813 1000 -- and permanently delete all
> copies of this transmission from your mail server(s), mail client(s) and
> from any physical records. Park Lane Information Technology has no liability
> (including liability in negligence) for any unauthorised use of the
> information contained in this transmission.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83