Re: How to get stored procedure args list from metadata tables ?

Excellent !
Thank You very much !

-----Original Message-----
From: Albe Laurenz [mailto:laurenz(dot)albe(at)wien(dot)gv(dot)at]
Sent: Wednesday, February 13, 2013 9:30 AM
To: Gauthier, Dave; pgsql-general(at)postgresql(dot)org
Subject: RE: How to get stored procedure args list from metadata tables ?

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