Database Reference
In-Depth Information
pgAdmin Query tool allows you to have multiple active sessions. The Query tool has a
good-looking
Visual
Explain
feature, as well as a Graphical Query Builder, as shown
in the following screenshot:
How it works...
pgAdmin provides a wide range of features, many of which are provided by other tools as
well. That gives us the opportunity to choose which of those tools we like or dislike, and for
many reasons, it is best to use the right tool for the right job, and that is always a matter of
expertise, experience, and personal taste.
pgAdmin submits SQL to the PostgreSQL server, and displays the results quickly and easily.
As a browser, it is fantastic. For performing small DBA tasks, it is ideal. As you might guess
from these comments, I don't recommend pgAdmin for
every
task.
Scripting is an important technique for DBAs: you keep a copy of the task executed, and you can
edit and resubmit if problems occur. It's also easy to put all the tasks in a script into a single
transaction, which isn't possible using current GUI tools. pgAdmin provides pgScript, which only
works with pgAdmin, so is much less easily ported. For scripting, I strongly recommend the psql
utility, which has many additional features you'll grow to appreciate over time.
