retrieve function members types/domains <= types

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: retrieve function members types/domains <= types
Date: 2010-09-26 21:26:41
Message-ID: 20100926232641.65b23f80@anubis.defcon1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

I'm trying to make a rights manager that retrieve all its info from PG
tables.

I found out how to retrieve function names; but now I'm stuck after that,
as I can't find a way to retrieve types/domains used by a function in order
to "rebuild" it in my manager and be able to test/set user rights on this
function, like:
SELECT has_function_privilege('myfun(int,domain14)', 'execute');

What queries should I issue to get such info?

--
Texas law forbids anyone to have a pair of pliers in his possession.

Browse pgsql-novice by date

  From Date Subject
Next Message Mladen Gogala 2010-09-26 23:20:41 Not quite there yet
Previous Message William Furnass 2010-09-24 17:14:17 Re: