Re: getting function argument names from psql?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
Cc: "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 03:37:04
Message-ID: 2605.1152761824@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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 :-(

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jamie Deppeler 2006-07-13 03:45:36 Delete Problem
Previous Message Rich Shepard 2006-07-13 03:34:57 Re: SQL Standards Compliance With Case