Re: getting 'full' names of functions?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ashish Karalkar <ashishka(at)synechron(dot)com>
Cc: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: getting 'full' names of functions?
Date: 2009-03-02 15:07:57
Message-ID: 5521.1236006477@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ashish Karalkar <ashishka(at)synechron(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bryan Keith 2009-03-02 16:42:56 Re: postgres 8.2 doesn't start after ubuntu upgrade
Previous Message Ashish Karalkar 2009-03-02 13:51:41 Re: getting 'full' names of functions?