client tool

On Thu, 2003-05-15 at 19:33, Hegyvari Krisztian wrote:

Greetings,

I am looking for a client side application to help me develop my queries for PostgreSQL. The client is Windows, the server is on Linux. I am thinking of something similar to TOAD, which we use to develop our Oracle based applications. So far I have used a web based solution, but I would need something to handle more complex queries and situations. If there is absolutely none for Windows, I can cope with tools running on Linux, but I would prefer something under Windows.

Cheers,

Hegyvari Krisztian

pgAdmin II
Very nice Windows tool.

http://www.pgadmin.org/pgadmin2.php?ContentID=1

HTH

--

Andre Truter
Software Engineer
Registered Linux user #185282
ICQ #40935899 AIM: trusoftzaf
http://www.trusoft.za.net

<------------------------------------------------->
< The box said: Requires Windows 95 or better... >
< So I installed Linux >
<------------------------------------------------->

Do you know about OpenOffice.org's data access? It can build queries
visually.

I don't know if tora ( see freshmeat for url ) also run on windows. I
use it for schema and data browser, but it knows a lot.

Screenshots with these two are here :)
http://www.galuna.ro/prezentari/pachet_server.html

--
Marius Andreiana
Soluţii informatice bazate pe Linux / Linux-based IT solutions
www.galuna.ro

You will have to write some of the queries yourself in that tool.

Also, you will have to escape the single quotes with another.

and don't put a ';' at the end. There are some other quirks, but otherwise, it's really good. It doens't do the latest pgsql as far as I know , though.

Andre Truter wrote:

I am looking for a client side application to help me
develop my queries for PostgreSQL. The client is Windows,
the server is on Linux. I am thinking of something similar
to TOAD, which we use to develop our Oracle based applications.

Exactly! TOAD rocks for Oracle development. If you are
looking for the TOAD of PostgreSQL...you GOTTA get:

PostgreSQL Manager
http://www.ems-hitech.com/pgmanager

The professional version is $135. Worth EVERY penny. I used
TOAD like crazy and find that PostgreSQL rocks. It's got a
table wizard, sql editor, and stored procedure editor, and more.

Plus, I've been sending them bug reports and feature requests,
and thedevelopment team is VERY responsive in fixing and adding
features. Their latest 1.5 version rocks. You can download a
trial version from their site.

Ok, enought of a plug from me. I don't even work for them but
I do want them to succeed because the software rox!

Dante

D. Dante Lorenso
dante@lorenso.com
972-333-4139

On Friday 16 May 2003 1:42 am, D. Dante Lorenso wrote:

I am looking for a client side application to help me
develop my queries for PostgreSQL. The client is Windows,
the server is on Linux. I am thinking of something similar
to TOAD, which we use to develop our Oracle based applications.

Exactly! TOAD rocks for Oracle development. If you are
looking for the TOAD of PostgreSQL...you GOTTA get:

PostgreSQL Manager
http://www.ems-hitech.com/pgmanager

The professional version is $135. Worth EVERY penny. I used
TOAD like crazy and find that PostgreSQL rocks. It's got a
table wizard, sql editor, and stored procedure editor, and more.

Don't suppose you'd have time to write a proper review that could be posted on
techdocs?
--
Richard Huxton

Yes
pgmanager is good. but it hangs for me when I try to grant permission on
my database. - any such experience ?

Richard Huxton wrote: