Обсуждение: Using information_schema to find about function parameters?

Поиск
Список
Период
Сортировка

Using information_schema to find about function parameters?

От
Mario Splivalo
Дата:
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


Re: Using information_schema to find about function parameters?

От
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