From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Timothy Perrigo <tperrigo(at)wernervas(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: getting function argument names from psql? |
Date: | 2006-07-13 13:16:00 |
Message-ID: | 20060713131600.GA6902@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jul 12, 2006 at 11:37:04PM -0400, Tom Lane wrote:
> "Merlin Moncure" <mmoncure(at)gmail(dot)com> writes:
> > On 7/12/06, Timothy Perrigo <tperrigo(at)wernervas(dot)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 :-(
Back when, I submitted a psql patch to get the input names along with
their types. Shall I dig up that code this weekend?
Cheers,
D
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2006-07-13 13:20:51 | Re: Performance problem with query |
Previous Message | Merlin Moncure | 2006-07-13 13:10:52 | Re: stored function - array parameter - how many element in array ? |