Excellent ! Thank You very much !
-----Original Message----- From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] 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 > 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
