Re: Using information_schema to find about function parameters?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Using information_schema to find about function parameters?
Date: 2009-10-29 17:20:27
Message-ID: hccisj$keg$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Lee Hachadoorian 2009-10-29 17:50:38 Speed up UPDATE query?
Previous Message Mario Splivalo 2009-10-29 16:51:42 Using information_schema to find about function parameters?