Re: How can I list the function.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
Cc: "Harvey, Allan AC" <HarveyA(at)onesteel(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: How can I list the function.
Date: 2007-02-01 16:39:15
Message-ID: 19110.1170347955@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Shoaib Mir" <shoaibmir(at)gmail(dot)com> writes:
> On 2/1/07, Harvey, Allan AC <HarveyA(at)onesteel(dot)com> wrote:
>> I know the function is there.
>> What am I doing wrong?

> To reduce clutter, \df does not show data type I/O functions. This is
> implemented by ignoring functions that accept or return type cstring.

That could be Allan's problem right there. The other likely possibility
I can think of is that delete_old() is in a schema that's not in his
search path. "\df+ delete_old" would only show visible functions --- to
see functions in all schemas try "\df+ *.delete_old".

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2007-02-01 16:39:25 Re: I "might" have found a bug on 8.2.1 win32
Previous Message Tom Lane 2007-02-01 16:25:39 Re: Functions, composite types and Notice