Re: List of Functions - Mailing list pgsql-general

From Dinesh Pandey
Subject Re: List of Functions
Date
Msg-id 20050421132822.14337538AF@svr1.postgresql.org
Whole thread Raw
In response to List of Functions  (Rob Stone <robs@parklane.com.au>)
Responses Re: List of Functions  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
\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



pgsql-general by date:

Previous
From: "Christopher J. Bottaro"
Date:
Subject: CURRENT_TIMESTAMP and actual time
Next
From: Patrick.FICHE@AQSACOM.COM
Date:
Subject: Use of temporary tables in functions