From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Query Designer |
Date: | 2005-04-27 07:59:55 |
Message-ID: | 426f3fc3$0$24297$8fe63b2a@news.disputo.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-04-27 08:10:16 | Re: PRIMARY KEY on a *group* of columns imply that each |
Previous Message | Klint Gore | 2005-04-27 07:49:24 | Re: Why sequential scan for currval? |