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] RFE: Use JOIN instead of WHERE in Graphical Query Builder

2012-07-17 Thread Daniel Serodio (lists)
Nelson A. de Oliveira wrote: Hi! On Tue, Jul 17, 2012 at 7:36 PM, Daniel Serodio (lists) wrote: I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE clauses for joins. It would be nice if it generated JOIN clauses instead. Is there any kind of difference between WHERE o

Re: [pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

2012-07-17 Thread Nelson A. de Oliveira
Hi! On Tue, Jul 17, 2012 at 7:36 PM, Daniel Serodio (lists) wrote: > I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE > clauses for joins. It would be nice if it generated JOIN clauses instead. Is there any kind of difference between WHERE or JOINs in PostgreSQL? Aren't

[pgadmin-support] RFE: Use JOIN instead of WHERE in Graphical Query Builder

2012-07-17 Thread Daniel Serodio (lists)
I'm using pgAdmin 1.14.3, and its Graphical Query Builder generates WHERE clauses for joins. It would be nice if it generated JOIN clauses instead. Thanks in advance, Daniel Serodio -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription:

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
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 To: Guillaume Lelarge Cc: PgAdmin Support Sent: Tuesday, July 17, 2012 12:59 PM Subject: Re: [pgadmin-support] Sear

Re: [pgadmin-support] Unable to connect existing PGAdmin to existing PostgreSQL Db

2012-07-17 Thread Raymond O'Donnell
On 17/07/2012 17:37, Raymond O'Donnell wrote: > On 17/07/2012 14:14, Zhang, Nancy wrote: >> Thank you Ray. >> >> There isn't any file named pgpass.conf in my computer after my >> searching attempt. Is there any other reasons? And is there a way >> that I delete in a clean way and resintall it? > >

Re: [pgadmin-support] Unable to connect existing PGAdmin to existing PostgreSQL Db

2012-07-17 Thread Raymond O'Donnell
On 17/07/2012 14:14, Zhang, Nancy wrote: > Thank you Ray. > > There isn't any file named pgpass.conf in my computer after my > searching attempt. Is there any other reasons? And is there a way > that I delete in a clean way and resintall it? If there's no pgpass.conf file, then that's why you're

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

Re: [pgadmin-support] Unable to connect existing PGAdmin to existing PostgreSQL Db

2012-07-17 Thread Zhang, Nancy
Thank you Ray. There isn't any file named pgpass.conf in my computer after my searching attempt. Is there any other reasons? And is there a way that I delete in a clean way and resintall it? Regards, Naixian (Nancy) Zhang Product Specialist | Global Client Solutions Revere Data 60 East 42nd Str

Re: [pgadmin-support] Unable to connect existing PGAdmin to existing PostgreSQL Db

2012-07-17 Thread Raymond O'Donnell
On 17/07/2012 07:57, Guillaume Lelarge wrote: > On Mon, 2012-07-16 at 21:59 +, Zhang, Nancy wrote: >> So what Should I do? Tons of thanks! >> > > Please, send the emails to the mailing list, not only me. > > What should you do? I have no idea. All I know is that it works, and > suddenly it do