pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing information_schema to find about function parameters?
2+ messages / 2 participants
[nested] [flat]
* Using information_schema to find about function parameters?
@ 2009-10-29 16:51 Mario Splivalo <mario.splivalo@megafon.hr>
2009-10-29 17:20 ` Re: Using information_schema to find about function parameters? Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 1 reply; 2+ messages in thread
From: Mario Splivalo @ 2009-10-29 16:51 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Using information_schema to find about function parameters?
2009-10-29 16:51 Using information_schema to find about function parameters? Mario Splivalo <mario.splivalo@megafon.hr>
@ 2009-10-29 17:20 ` Thomas Kellerer <spam_eater@gmx.net>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas Kellerer @ 2009-10-29 17:20 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-10-29 17:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-10-29 16:51 Using information_schema to find about function parameters? Mario Splivalo <mario.splivalo@megafon.hr>
2009-10-29 17:20 ` Thomas Kellerer <spam_eater@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox