Re: Re: What's the best front end/client under MS Windows?

Hi Greg,

Instead of using psql to get the NOTICES, when I program in PL/pgSQL, I
start the database with -d 2 (debug level of 2) and this forces the
NOTICES into the PostgreSQL log file.

Then, I just have a telnet/ssh/etc session on the server running :

tail -f postgresql.log

So I constantly have access to the NOTICES which PostgreSQL generates,
regardless of how I'm hitting it.

Would this be useful to you?

:-)

Regards and best wishes,

Justin Clift

Gregory Wood wrote:
>
> I'm partial to the ZEOS Database Explorer myself. I don't have experience
> with a multitude of tools, so the best I can offer is that I have no
> problems with the latest version :) Actually, I can tell you that it has the
> advantage of a native interface (rather than relying on ODBC). And it's
> free, that's always an advantage.
>
> Oh, and it does have the disadvantage of not showing NOTICEs, which is a
> pain in the ass when doing benchmarking via EXPLAIN, for which I'm forced to
> use psql. There were some problems in older versions (specifically it was
> having trouble stripping out spaces on newlines and with quoting on
> triggers), but those problems seem to be resolved with the latest version.
> It's not the most stable program, but most people don't use Windows for
> stability...
>
> Address is http://www.zeoslib.org/ but it appears to be down at the moment.
>
> Greg
>
> ----- Original Message -----
> From: "Walter Chong" <mail2walter(at)yahoo(dot)com>
> To: <pgsql-general(at)postgresql(dot)org>
> Sent: Friday, May 11, 2001 11:03 PM
> Subject: What's the best front end/client under MS Windows?
>
> > Kindly list the advantages/disadvantages for me, THX!
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi