Excellent ! Thank You very much ! -----Original Message----- From: Albe Laurenz [mailto:laurenz.albe@xxxxxxxxxx] Sent: Wednesday, February 13, 2013 9:30 AM To: Gauthier, Dave; pgsql-general@xxxxxxxxxxxxxx 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
