Query analyzer for postgresql wanted

From: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Query analyzer for postgresql wanted
Date: 2002-09-23 14:52:56
Message-ID: 3D8F2AC8.AB25802C@t1.unisoftbg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I post it for second time ( sorry about it.).

I need to have a good query analyzer by develompment.
I am new to postgresql and I are working with oracle for many years.
I oracle exist very good tool, that point me exact for mistake in my
query.

For examplme :
select A.a,( 15 + A.b) .... from mytable A ... where A.id in ( select
....)

If I make mistake in posgres ( I use pgAdmin), I only receive message:
"error near '('" (for example).
Bu in my query I can have many '('.

In oracle I receive:
select A.a,( 15 + A.b) .... from mytable A ... where A.id in ( select
....)
* (error ... ).

And I can very quick get the error.

Exist any good tools for this in postgresql?

Many thanks,
Ivan.

Responses

  • information at 2002-10-16 15:30:30 from Florian Litot

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-09-23 14:58:45 Re: output format for dates
Previous Message Johnson, Shaunn 2002-09-23 14:51:14 rotatelog / logrotate with PostgreSQL