Re: [pgadmin-support] Search the schema

2012-07-19 Thread Guillaume Lelarge
On Thu, 2012-07-19 at 05:40 -0500, Michael Shapiro wrote: > Of course, makes sense, which is why I made the feature request I did > (ie, search). Would you consider adding regex expressions to the > search? > Well, it wouldn't be hard to do because the search is done by PostgreSQL. So we can use

Re: [pgadmin-support] Search the schema

2012-07-19 Thread Michael Shapiro
Of course, makes sense, which is why I made the feature request I did (ie, search). Would you consider adding regex expressions to the search? On Thu, Jul 19, 2012 at 3:13 AM, Guillaume Lelarge wrote: > On Wed, 2012-07-18 at 21:47 -0500, Michael Shapiro wrote: > > What motivated me to ask for thi

Re: [pgadmin-support] Search the schema

2012-07-19 Thread Guillaume Lelarge
On Wed, 2012-07-18 at 21:47 -0500, Michael Shapiro wrote: > 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 functio

Re: [pgadmin-support] Search the schema

2012-07-18 Thread Michael Shapiro
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

Re: [pgadmin-support] Search the schema

2012-07-18 Thread Guillaume Lelarge
On Tue, 2012-07-17 at 20:52 +0200, Guillaume Lelarge wrote: > On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro 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, i

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Michal Kozusznik
Dne 17.7.2012 20:52, Guillaume Lelarge napsal(a): On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro 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,

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Michael Shapiro
I do keep the code in a versioning system. And that is a big help. But that doesn't solve the problem of what is actually installed. Searching the schema would be a big help. On Tue, Jul 17, 2012 at 3:41 PM, Fernando Hevia wrote: > > > On Tue, Jul 17, 2012 at 3:52 PM, Guillaume Lelarge > wrote:

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Fernando Hevia
On Tue, Jul 17, 2012 at 3:52 PM, Guillaume Lelarge wrote: > On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro 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, > i

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Guillaume Lelarge
On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro 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. > That won't do it. First time I hea

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Guillaume Lelarge
On Tue, 2012-07-17 at 10:18 -0700, Francisco Leovey wrote: > Do a backup in sql mode (not compressed) and load the output to a text > editor. > There you can find anything you need. > That's what he does already. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sen

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Francisco Leovey
] 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 wrote: On Tue, 2012-07-

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Michael Shapiro
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 wrote: > On Tue, 2012-07-17 at 09:44 -0500, Michae

Re: [pgadmin-support] Search the schema

2012-07-17 Thread Guillaume Lelarge
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 th

[pgadmin-support] Search the schema

2012-07-17 Thread Michael Shapiro
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 fe