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.kla...@gmail.com] 
Sent: Wednesday, February 13, 2013 9:26 AM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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.kla...@gmail.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to