Re: Inquiry From Form [pgsql]

On Friday 04 April 2003 22:19, Ami Tabak wrote:

> One of the main features of the  product is the ability for none
> programming users to do \"on the fly\" sql queries on the data the number
> crunching sub system produces.
>
> I\'m looking for an application that will serve as the user\'s graphic
> front end, something like Microsoft\'s Access front end. Reasons for not
> using MSAccess in the first place are commercial reasons.

If you're looking for something exactly like the Access front-end, I believe 
you're out of luck.  The GUIs I have seen for PostgreSQL range from very 
crude to somewhat crude (pgaccess, pgadmin, tora).  TOra is a very polished 
GUI, but it's far from being polished for the PostgreSQL support.  Its Oracle 
support is very polished, however, so I would imagine it'll eventually be 
polished for PostgreSQL support.

OTOH, if you're wanting a Java solution, the only one you can probably 
consider is DB Visualizer.  It's very polished, and supports any database 
with a JDBC driver.  Best of all, it's free as in beer.

The URL for DB Visualizer is http://www.minq.se/products/dbvis/index.html.
The URL for TOra is http://www.globecom.se/tora/.
pgaccess comes with PostgreSQL, and requires the TCL and TK runtimes.
There is another pgaccess downloadable separately (I'm guessing it's the same 
GUI, but the one in the PostgreSQL tree is not the same..I suspect the one in 
the tree has not been updated in a while).  The URL is 
http://www.pgaccess.org/index.php?page=Users.
The URL for pgadmin is http://pgadmin.postgresql.org/.  pgmigration is also 
available from here.  It is a plugin for pgadmin II, that facilitates 
migration from Oracle to PostgreSQL.