Re: How to get stored procedure args list from metadata tables ? - Mailing list pgsql-general

Hello

2013/2/13 Gauthier, Dave <dave.gauthier@intel.com>:
> 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 ot=
her
> pg_proc columns.
>

It is in pg_proc - argument's description is stored in combination of
fields: pronargs, pronargdefaults, proargtypes, proallargtypes,
proargmodes, proargnames, proargdefaults

system function pg_get_function_arguments can returns usual description



postgres=3D# select pg_get_function_arguments('check_form_rodne_cislo'::reg=
proc);
 pg_get_function_arguments
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=
=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=
=E2=94=80=E2=94=80=E2=94=80
 character varying, boolean
(1 row)

regards

Pavel Stehule

>
>
> Thanks in Advance for any help.