Re: getting function argument names from psql? - Mailing list pgsql-general

From Tom Lane
Subject Re: getting function argument names from psql?
Date
Msg-id 2605.1152761824@sss.pgh.pa.us
Whole thread Raw
In response to Re: getting function argument names from psql?  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: getting function argument names from psql?  (David Fetter <david@fetter.org>)
List pgsql-general
"Merlin Moncure" <mmoncure@gmail.com> writes:
> On 7/12/06, Timothy Perrigo <tperrigo@wernervas.com> wrote:
>> Is there a way to get the names of the arguments to a function from
>> psql?  /df and /df+ return the parameter types, but not their names.

> select oid::regprocedure from pg_proc where proname like 'your name here';

Nope, because regprocedureout doesn't include argument names (nor modes).
I think the best way ATM is to look directly at pg_proc.proargnames :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: SQL Standards Compliance With Case
Next
From: Jamie Deppeler
Date:
Subject: Delete Problem