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 <mshapir...@gmail.com>
To: Guillaume Lelarge <guilla...@lelarge.info> 
Cc: PgAdmin Support <pgadmin-support@postgresql.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 <guilla...@lelarge.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
>
>

Reply via email to