From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Julius Tuskenis <julius(at)nsoft(dot)lt> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Graphical Query Builder - usage stats? |
Date: | 2010-03-17 11:31:49 |
Message-ID: | 4BA0BDA5.6000206@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Le 15/03/2010 09:54, Julius Tuskenis a écrit :
> [...]
> I don't usually use the builder, but sometimes it is convenient for long
> table/column names having queries. I'd like to propose some improvements
> to it:
> 1. Why not join the selected tables if they are related over foreign
> key? Usually well designed database uses FK to keep relations in order,
> so when you drop a new table to a query builder window there could be
> checked if the table can be linked to the already used tables in builder.
> 2. I think, that tables should be linked using join statement, not the
> where clause. That way we could have left, right and inner joins easily.
>
> I think these 2 impovements would make the builder more usable :).
>
Sure, that would be interesting. I added a ticket to remember about your
feature request: http://code.pgadmin.org/trac/ticket/150 .
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-03-17 11:34:58 | Re: Can't access entire window in Graphical Query Builder (Windows platform) |
Previous Message | javib | 2010-03-17 11:29:34 | Re: Creating a new database in pgadmin |