Re: Search the schema

What motivated me to ask for this feature was that I was looking to see if
the dependents/dependencies tabs
on function would show all the objects that use the function and the
objects that the functions uses, including other functions, views, etc.
Those relationships, I realize, are not explicitly maintained by Postgres,
but if PgAdmin could emulate that, it would be great.
But probably hard, so the search was the next best thing.

Given that functions have multiple signatures (same function name with a
variable number of args), I'd like to be able to find all the places
that one variant of the function is used. For example if there is a
function A with two variants: A(int,int) and A(int, text) -- I'd like to be
able to see where
A(int, text) is used.

On Tue, Jul 17, 2012 at 10:59 AM, Michael Shapiro <mshapiro51(at)gmail(dot)com>wrote:

> No, it doesn't.
>
> For example, I want to see if a given string is used within a function.
> I want to be able to see all the uses of a function: in other functions,
> in select stmts in views, etc.
>
>
>
>
> On Tue, Jul 17, 2012 at 10:39 AM, Guillaume Lelarge <
> guillaume(at)lelarge(dot)info> wrote:
>
>> On Tue, 2012-07-17 at 09:44 -0500, Michael Shapiro wrote:
>> > I am looking for the ability to search the schema. I'd like to be able
>> to
>> > see, for example, where a particular string occurs in a function or a
>> view
>> > or table (or perhaps other objects). Right now I am forced to dump the
>> > schema and then search outside PgAdmin.
>> >
>> > So, I guess, I am asking for such a feature to be added to PgAdmin.
>>
>> pgAdmin 1.16 (right now in beta) gives you the ability to search for
>> objects' names that contain a specific string. But I guess it doesn't go
>> as far as you want, does it?
>>
>>
>> --
>> Guillaume
>> http://blog.guillaume.lelarge.info
>> http://www.dalibo.com
>>
>>
>