Oracle Tips by
standard of IDEs for PostgreSQL and PostgreSQL derivatives such as
EnterpriseDB is pgAdmin III. pgAdmin III is completely
free and is
an open source tool that ships with PostgreSQL.
a lawyer so I will not get into details but pgAdmin is released under
the Artistic License. I believe that means that you can do
whatever you want with it as long as you give the authors credit for
what they have done.
interface to pgAdmin III (Figure 5.59) will be very familiar. It
looks and works much like Developer Studio.
5.59: pgAdmin III
has been around for
long time. The first version was available for PostgreSQL 6.
It is heavily tested and very reliable. It doesn't offer much
that is not available in Developer Studio except support for the
additional procedural languages.
data in tables (Figure 5.60) is much like using SQL Interactive in
5.60: pgAdmin III View Data
is very much like Developer Studio's SQL Interactive. I like the
pgAdmin history feature better than the Developer Studio history
(which I find to be in an annoying location).
5.61: pgAdmin III Query Tool
III is a fully functional tool
is the appropriate choice for many situations. I keep it
installed and use it regularly.
Manager for PostgreSQL Lite
Manager has the most
interface of all the tools I use. It has a very Windows-like
interface and I personally like it for its ease of use.
thing I don't like is that it has its own names for things instead of
using the more familiar words that all the other tools use. For
example, instead of adding a server or defining a connection, you will
register a host or register a database. That's a minor complaint
though as it is very easy to figure out.
interface (Figure 5.62) provides much more information than the other
tools all on a single screen. You will either need a very large
screen or you will want to maximize the tool.
5.62: EMS SQL Manager Lite
data and running queries in SQL Manager is a bit different than the
other tools. Everything is integrated in a single MDI window and
you don't have to run a separate query to view data (Figure 5.63) in a
table selected in the navigator node. It's just a different tab
in the same window.
5.63: EMS SQL Manager View Data
your own queries is also done within the same window (Figure 5.64).
5.64: EMS SQL Manager Query Editor
view the results of the query, you select the results table (Figure
5.65). Errors are displayed on the log tab.
5.65: EMS SQL Manager View Query Results
the tools in this chapter, I like the interface to EMS SQL Manager the
best. Then again, I prefer the windows interface.
do like EMS SQL Manager, you can upgrade to the commercial version to
gain additional functionality, or you can purchase the SQL Studio pack
that gives you all of the tools you will need for managing your
environments. The full, paid version gives you a graphical query
builder and a visual explain.
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.