Re: getting 'full' names of functions? - Mailing list pgsql-admin

From Tom Lane
Subject Re: getting 'full' names of functions?
Date
Msg-id 5521.1236006477@sss.pgh.pa.us
Whole thread Raw
In response to Re: getting 'full' names of functions?  (Ashish Karalkar <ashishka@synechron.com>)
Responses Re: getting 'full' names of functions?  (Jan-Peter.Seifert@gmx.de)
List pgsql-admin
Ashish Karalkar <ashishka@synechron.com> writes:
> Jan-Peter Seifert wrote:
>> Obviously you can't just use the specific_name from information_schema.routine_privileges for this.

> May be this will help you:

Easier is just
    select oid::regprocedure from pg_proc where <whatever>

            regards, tom lane

pgsql-admin by date:

Previous
From: Ashish Karalkar
Date:
Subject: Re: getting 'full' names of functions?
Next
From: "Bryan Keith"
Date:
Subject: Re: postgres 8.2 doesn't start after ubuntu upgrade