Re: List of Functions

From: "Dinesh Pandey" <dpandey(at)secf(dot)com>
To: "'Rob Stone'" <robs(at)parklane(dot)com(dot)au>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: List of Functions
Date: 2005-04-21 13:25:31
Message-ID: 20050421132822.14337538AF@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

\df
\df functionname

Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Rob Stone
Sent: Thursday, April 21, 2005 9:48 AM
To: 'pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick.FICHE 2005-04-21 13:33:19 Use of temporary tables in functions
Previous Message Dawid Kuroczko 2005-04-21 13:13:42 Re: Filesystem options for storing pg_data