Dave Gauthier wrote:
> 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.
This information is in the following columns of pg_proc:
proargtypes, proallargtypes, proargmodes, proargnames
For a nice display, use
SELECT pg_get_function_identity_arguments('funcname'::regproc);
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
