Home > mailing lists

Re: Using information_schema to find about function parameters? - Mailing list pgsql-sql

From	Thomas Kellerer
Subject	Re: Using information_schema to find about function parameters?
Date	October 29, 2009 17:20:56
Msg-id	hccisj$keg$1@ger.gmane.org Whole thread Raw
In response to	Using information_schema to find about function parameters? (Mario Splivalo <mario.splivalo@megafon.hr>)
List	pgsql-sql

Tree view

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 by date:

From: Mario Splivalo
Date: 29 October 2009, 16:58:52
Subject: Using information_schema to find about function parameters?

From: Lee Hachadoorian
Date: 29 October 2009, 17:50:51
Subject: Speed up UPDATE query?

Re: Using information_schema to find about function parameters? - Mailing list pgsql-sql

Previous

Next