Excellent !
Thank You very much !
-----Original Message-----
From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at]=20
Sent: Wednesday, February 13, 2013 9:30 AM
To: Gauthier, Dave; pgsql-general@postgresql.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=20
> are passed to a stored procedure. Doesn't seem to be in pg_proc.prosrc o=
r 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