Postgres Pro
Downloads
Home   >   mailing lists

Thread: List of Functions

List of Functions

From
Rob Stone
Date:
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.

Re: List of Functions

From
"Dinesh Pandey"
Date:
\df
\df functionname


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

Re: List of Functions

From
Oleg Bartunov
Date:
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