Re: Query Designer - Mailing list pgsql-general

From Hannes Dorbath
Subject Re: Query Designer
Date
Msg-id 426f3fc3$0$24297$8fe63b2a@news.disputo.net
Whole thread Raw
In response to Query Designer  (Carlos Gustavo Fischer <cgfischer@gmail.com>)
Responses Re: Query Designer  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-general
The SQL generated by tools like that is mostly neither performant nor
readable in particular.

Better learn basic SQL and use an editor with keyboard templates. That
way you'll be writing your statements even faster than cicking arround
in some stupid GUI ;)

And yes, PGExplorer is the only FREE query builder I know off as well.
There are several commercial..

> a lot of WHERE... =...AND...=...AND...

Maybe it creates implicit joins?


On 26.04.2005 21:35, Carlos Gustavo Fischer wrote:
> Hello, people.
>
> I´m looking for a FREE tool where you can VISUALLY link tables and
> mark fields and the tool
> generates the query automatically.
>
> I´ve tried PGExplorer. It´s nice, but it doens´t create "JOINS", just
> a lot of WHERE... =...AND...=...AND...
>
> Do you people have any tips ??
>
> Thanks in advance,
> Carlos G. Fischer
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

pgsql-general by date:

Previous
From: Klint Gore
Date:
Subject: Re: Why sequential scan for currval?
Next
From: Richard Huxton
Date:
Subject: Re: PRIMARY KEY on a *group* of columns imply that each