Re: Visual query builder for PosgreSQL?
От | Guillaume Lelarge |
---|---|
Тема | Re: Visual query builder for PosgreSQL? |
Дата | |
Msg-id | 1360840801.2044.13.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Visual query builder for PosgreSQL? (Russell Keane <Russell.Keane@inps.co.uk>) |
Список | pgsql-general |
On Fri, 2013-02-08 at 11:37 +0000, Russell Keane wrote: > > I'm looking for some good visual query builder which can be used by non-tech people for some ETL tasks. Do you have anyrecommendation? > > > > Now, we're moving our data from Excel to PostgreSQL to deal with large amount of data, and we need to process some ETLtasks, with using JOIN and GROUP BY between tables, up to 10 tables on it. > > > > Of course, I can write ad-hoc queries by myself. However, I'd like to allow non-tech people to issue ad-hoc queries withusing some visual query builder. > > > > I have already looked a query builder feature in pgAdminIII, but I'm not sure whether I can use GROUP BY with it. > > > > Do you have any experience or recommendation about visual query builder for PostgreSQL? > > You can do joins in the PGAdmin3 query builder but I'm fairly sure you can't do group by's. > Correct. The pgAdmin3 graphical query builder doesn't support GROUP BY. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
В списке pgsql-general по дате отправления: