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@gmail.com