Re: Query Designer

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

In response to

Responses

Browse pgsql-general by date

  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?