| Lists: | pgsql-general |
|---|
| From: | Caleb Palmer <palmer(dot)caleb(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Web-based Graphical Query Building Tool for PostgreSQL |
| Date: | 2011-07-13 13:02:48 |
| Message-ID: | CAC8ZfUZrYyzYLHCOFcEJffkj9uzhv=d77XGcPV3HWn7_1Au-Kw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi all,
My company sells software that uses PostgreSQL and the need has come up to
provide a tool that gives our clients access to query the database but we
don't want to expect these users to be able to use SQL. Is there a product
out there that provides a graphical query builder? Preferably web-based. I
know that Pgadmin as a graphical query building.
Thanks in advance,
Caleb Palmer
| From: | Joseph Marlin <joseph(dot)a(dot)marlin(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Web-based Graphical Query Building Tool for PostgreSQL |
| Date: | 2011-07-13 15:55:45 |
| Message-ID: | 02e28abe-bb3c-4a45-ad0f-51fab545be8b@glegroupsg2000goo.googlegroups.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
phpPgAdmin works great for me! You can do most simple queries without any SQL, including add, select, update, sort (order by), alter, create, drop, etc etc. All that can be done just by clicking buttons and labels in the browser. There is the ability to execute actual SQL queries if your users know how. http://phppgadmin.sourceforge.net/doku.php?id=start
| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Web-based Graphical Query Building Tool for PostgreSQL |
| Date: | 2011-07-14 02:03:05 |
| Message-ID: | 4E1E4E59.6060905@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 13/07/2011 9:02 PM, Caleb Palmer wrote:
> Hi all,
>
> My company sells software that uses PostgreSQL and the need has come up
> to provide a tool that gives our clients access to query the database
> but we don't want to expect these users to be able to use SQL. Is there
> a product out there that provides a graphical query builder? Preferably
> web-based. I know that Pgadmin as a graphical query building.
Check out iReport builder, Crystal Reports, etc.
If you need query building for purposes other than reporting, I'm not
really sure where to go for that.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/
| From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Web-based Graphical Query Building Tool for PostgreSQL |
| Date: | 2011-07-14 07:05:23 |
| Message-ID: | 4E1E9533.2040704@compulab.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 07/13/2011 04:02 PM, Caleb Palmer wrote:
> Hi all,
>
> My company sells software that uses PostgreSQL and the need has come
> up to provide a tool that gives our clients access to query the
> database but we don't want to expect these users to be able to use
> SQL. Is there a product out there that provides a graphical query
> builder? Preferably web-based. I know that Pgadmin as a graphical
> query building.
>
> Thanks in advance,
> Caleb Palmer
Open Office Base has a graphical query interface similar to MS Access.
I wouldn't say its a perfect environment, but it may be what you need.
Sim