Using information_schema to find about function parameters?

[Mario Splivalo-3]

I looked at the information_schema.routines, to get information about
the functions in the database, but there doesn't seem to be a way to
extract the parameters information about functions? Where would I seek
for such information?

        Mike

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

[Thomas Kellerer]

Mario Splivalo, 29.10.2009 17:51:
> I looked at the information_schema.routines, to get information about
> the functions in the database, but there doesn't seem to be a way to
> extract the parameters information about functions? Where would I seek
> for such information?

They are stored as an array in pg_proc (proargnames, proallargtypes)

http://www.postgresql.org/docs/current/static/catalog-pg-proc.html

Thomas


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