Re: Graphical Query Builder - usage stats?
От | Julius Tuskenis |
---|---|
Тема | Re: Graphical Query Builder - usage stats? |
Дата | |
Msg-id | 4B9DF5B4.1010505@nsoft.lt обсуждение исходный текст |
Ответ на | Graphical Query Builder - usage stats? (Mario Splivalo <mario.splivalo@megafon.hr>) |
Ответы |
Re: Graphical Query Builder - usage stats?
|
Список | pgadmin-support |
Hello, 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 :). Thank you for the tool anyway. Great job :) -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050
В списке pgadmin-support по дате отправления: