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