First of all I wish
to say Hi, since I am new to this list.
My name is Cameron
Braid.
I am going to be
using PostgreSQL in a new project.
This project is a
Java Web Application, using the Hibernate framework + JDBC for accessing
PostgreSQL.
I have been a happy
mySQL user for a while, but things are starting to shit me.. I'll not start a
mySQL vs PostgreSQL war, i'll just start using postgreSQL :)
The pgadmin tool is
a great product. I have come originally from SQL Server, using enterprise
manager, then after that mysql using myCC.
I am both
comfortable at using both command line / shell style SQL tools, and GUI
tools.
However some of the
woth that I have been doing lately requires ad hoch direct database updates, and
using a GUI to do this makes it a simple task.
Currently the
pgadmin grid editor works sufficiently to do this, except it is a little painful
having to go through these steps to edit the relevant data (in multiple tables)
for a single task.
* right click
on table name
* choose "view
data"
* enter
filter
* click
go
* make
changes
* swap to
pgadmin to start agin with new table.
In myCC you can have
the SQL window open with multiple SQL statements ready, you
just
* select the
statement
* execute it
eith CTRL-E
* make
changes
* repeat for each
statement
The only condition
is that the statement that you are executing is a "select * from ..."
statement.
I would LOVE it for
pgadmin to support launching the grid editor as an embeded tab in the query
window.
Currently there are
3 execute actions to run the selected query
a) execute
b) execute with
export
c) explain.
A fourth one
d) execute for
update
would be a fantastic
addition
Once again, thanks
for such a valuable tool.
Cameron.