Database Reference
In-Depth Information
psql
psql is a command-line interface for running queries. It is included in all distributions
of PostgreSQL. psql has some unusual features, such as an import and export command
for delimited files (CSV or tab), and a minimalistic report writer that can generate
HTML output. psql has been around since the beginning of PostgreSQL and is the tool
of choice for many expert users, for people working in consoles without a GUI, or for
running common tasks in shell scripts. Newer converts favor GUI tools and wonder
why the older generation still clings to the command line.
pgAdmin
pgAdmin
is a widely used free GUI tool for PostgreSQL. You can download it separately
from PostgreSQL if it isn't already packaged with your installer.
pgAdmin runs on the desktop and can connect to multiple PostgreSQL servers regard‐
less of version or OS.
Even if your database lives on a console-only Linux server, go ahead and install pgAdmin
on your workstation, and you'll find yourself armed with a fantastic GUI tool.
An example of pgAdmin appears in
Figure 1-1
.
Figure 1-1. pgAdmin
