Milen A. Radev a ecrit le 14/03/2007 16:55:
Kevin Macdonald wrote:
Version: pgAdmin III 1.6.2
I would like to make two feature requests for the "Query Tool".
Background: Our environment includes a number Postgres installations.
For each installation, we have defined a number of accounts (eg.
postgres, and various restricted user-level accounts.)
REQUEST 1
---------
Often, I have a number of "Query Tool" windows open at any one time --
each connected to a different database and through a different account.
It would be very useful to know which window points where. One way would
be to print the name of the database and account, through which the
connection was made, in the title bar of the Query Tool window.
Currently, the title bar is empty.
That's known bug (reported here -
http://www.pgadmin.org/archives/pgadmin-support/2007-01/msg00014.php) in
1.6.2 and fixed for 1.6.3.
REQUEST 2
---------
I also use SQL*Navigator to access our Oracle installations. On useful
feature is that it allows multiple SQL statements to appear in the
window, and it lets you run an arbitrary statement by positioning your
cursor on the line and press F5.
Of course, each statement would have to be terminated by a semi-colon.
For example:
---------------------
select * from foo;
update foo set col = 'Fred';
---------------------
If the cursor was positioned on line 1, when you press F5, the SELECT
would run; if the cursor was on line 2, when you press F%, the UPDATE
would run.
Very similar feature is already available - select any text in the query
tool and press F5. The selected text is treated as a complete query and
is executed. Please report your experience with this feature and suggest
improvements if it does not meet your needs.
Oups, it seems they are already done... I'll try them tonight.
--
Guillaume.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
