Re: getting 'full' names of functions?

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

Jan-Peter(dot)Seifert(at)gmx(dot)de writes:
> I combined your suggestions into this query I'll be using for now:

> SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM

This is flat *wrong*, as you'll soon find if you are working with
functions in more than one schema. regprocedure already puts a
schema qualification on the name if one is needed.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Yauheni Labko 2009-03-04 20:41:06 Re: standby waiting for what?
Previous Message Tom Lane 2009-03-04 20:37:14 Re: Postgressql backup/restore question