Re: Using information_schema to find about function parameters?

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Using information_schema to find about function parameters?
Дата
Msg-id hccisj$keg$1@ger.gmane.org
обсуждение исходный текст
Ответ на Using information_schema to find about function parameters?  (Mario Splivalo <mario.splivalo@megafon.hr>)
Список pgsql-sql
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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Using information_schema to find about function parameters?
Следующее
От: Lee Hachadoorian
Дата:
Сообщение: Speed up UPDATE query?