getting 'full' names of functions?

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: getting 'full' names of functions?
Date: 2009-03-02 12:20:20
Message-ID: 20090302122020.137490@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

before I reinvent the wheel I'd like to know whether there's a shortcut for getting the 'full' name (incl. argtypes) of the functions within a database in order to REVOKE priviliges on them given to certain users.
I don't see anything in the docs: http://www.postgresql.org/docs/8.3/interactive/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE

Obviously you can't just use the specific_name from information_schema.routine_privileges for this.

Any help is appreciated.

Thank you very much,

Peter
--
Computer Bild Tarifsieger! GMX FreeDSL - Telefonanschluss + DSL
für nur 17,95 ¿/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ashish Karalkar 2009-03-02 13:51:41 Re: getting 'full' names of functions?
Previous Message Gerd König 2009-03-02 09:06:53 Re: Implementing PITR