Visual query builder for PosgreSQL?

From: Satoshi Nagayasu <snaga(at)uptime(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: Visual query builder for PosgreSQL?
Date: 2013-02-08 07:42:17
Message-ID: 5114AC59.7050409@uptime.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm looking for some good visual query builder which can be used by
non-tech people for some ETL tasks. Do you have any recommendation?

Now, we're moving our data from Excel to PostgreSQL to deal with large
amount of data, and we need to process some ETL tasks, 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 with using 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?

Regards,
--
Satoshi Nagayasu <snaga(at)uptime(dot)jp>
Uptime Technologies, LLC. http://www.uptime.jp

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-02-08 08:34:54 Re: DEFERRABLE NOT NULL constraint
Previous Message Pavel Stehule 2013-02-08 05:32:06 Re: pl/java for postgresql 9.2