Actually, how do you discriminate between 2 different procedures that have the same name but different number of args (using pg_get_function_arguments)? The function bocks when the procedure name is not unique. -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxx] Sent: Wednesday, February 13, 2013 9:26 AM To: Gauthier, Dave Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: How to get stored procedure args list from metadata tables ? On 02/13/2013 06:13 AM, Gauthier, Dave wrote: > Hi: > > 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. > > Thanks in Advance for any help. > http://www.postgresql.org/docs/9.2/interactive/catalog-pg-proc.html proargtype, proallargtypes, proargmodes, proargnames, proargdefaults Example: production=# SELECT proargnames from pg_proc where proname ='close_tag_order'; proargnames -------------------------------------- {_order_no,not_rcv_ct,tag_change_ct} -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
