Re: Search the schema

Do a backup in sql mode (not compressed) and load the output to a text editor.
There you can find anything you need.
 

________________________________
From: Michael Shapiro <mshapiro51(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: PgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Sent: Tuesday, July 17, 2012 12:59 PM
Subject: Re: [pgadmin-support] Search the schema

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
>
>