On Wed, Jul 12, 2006 at 11:37:04PM -0400, Tom Lane wrote: > "Merlin Moncure" <mmoncure@xxxxxxxxx> writes: > > On 7/12/06, Timothy Perrigo <tperrigo@xxxxxxxxxxxxx> 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@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
