Re: How to get stored procedure args list from metadata tables ? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: How to get stored procedure args list from metadata tables ?
Date
Msg-id A737B7A37273E048B164557ADEF4A58B057B2CE9@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to How to get stored procedure args list from metadata tables ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: How to get stored procedure args list from metadata tables ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Dave Gauthier wrote:
> Looking for a table or view which contains the list of arguments that are=
 passed to a stored
> procedure.  Doesn't seem to be in pg_proc.prosrc or other pg_proc columns=
.

This information is in the following columns of pg_proc:
proargtypes, proallargtypes, proargmodes, proargnames

For a nice display, use
SELECT pg_get_function_identity_arguments('funcname'::regproc);

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to get stored procedure args list from metadata tables ?
Next
From: "Gauthier, Dave"
Date:
Subject: Re: How to get stored procedure args list from metadata tables ?