Re: How can I list the function. - Mailing list pgsql-general

From Tom Lane
Subject Re: How can I list the function.
Date
Msg-id 19110.1170347955@sss.pgh.pa.us
Whole thread Raw
In response to Re: How can I list the function.  ("Shoaib Mir" <shoaibmir@gmail.com>)
Responses Re: How can I list the function. SOLVED  ("Harvey, Allan AC" <HarveyA@OneSteel.com>)
List pgsql-general
"Shoaib Mir" <shoaibmir@gmail.com> writes:
> On 2/1/07, Harvey, Allan AC <HarveyA@onesteel.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

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: I "might" have found a bug on 8.2.1 win32
Next
From: "George Pavlov"
Date:
Subject: Re: Subqueries - performance and use question