Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8186A6336A0 for ; Mon, 2 Mar 2009 08:20:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 56662-02 for ; Mon, 2 Mar 2009 08:20:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id C09926335EB for ; Mon, 2 Mar 2009 08:20:24 -0400 (AST) Received: (qmail 18430 invoked by uid 0); 2 Mar 2009 12:20:21 -0000 Received: from 192.124.237.8 by www073.gmx.net with HTTP; Mon, 02 Mar 2009 13:20:20 +0100 (CET) Content-Type: text/plain; charset="iso-8859-1" Date: Mon, 02 Mar 2009 13:20:20 +0100 From: "Jan-Peter Seifert" Message-ID: <20090302122020.137490@gmx.net> MIME-Version: 1.0 Subject: getting 'full' names of functions? To: pgsql-admin@postgresql.org X-Authenticated: #955937 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX194kikFs3V4/k/dh8USBo/Bqfs8smhQHnLcT+rRkv eJmWNoyi58lMqhVrQl3435MmCY0Z1Kp7qs4g== Content-Transfer-Encoding: 8bit X-GMX-UID: M/mYfdd9TXsuUVLyb2Q5rmBCRzdyMsOv X-FuHaFi: 0.67 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/14 X-Sequence-Number: 31514 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