From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to get stored procedure args list from metadata tables ? |
Date: | 2013-02-13 14:24:00 |
Message-ID: | CAFj8pRDkKmRPfGWMDBTpsrtYj=_6U3vfSkqgm+gYJczFrLyCPA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
2013/2/13 Gauthier, Dave <dave(dot)gauthier(at)intel(dot)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 other
> 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=# select pg_get_function_arguments('check_form_rodne_cislo'::regproc);
pg_get_function_arguments
────────────────────────────
character varying, boolean
(1 row)
regards
Pavel Stehule
>
>
> Thanks in Advance for any help.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-02-13 14:26:20 | Re: How to get stored procedure args list from metadata tables ? |
Previous Message | Albe Laurenz | 2013-02-13 14:22:15 | Re: Differences when calling query inside and outside cursor |