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
