PgAccess is a graphical administration application for PostgreSQL. It is designed to be
similar in function to PC database software, such as Microsoft Access.
Figure 6-1 displays the main PgAccess application window.
The interface allows you to view and modify various aspects of your PostgreSQL database using graphical representations
of database elements, such as tables, queries, and views (among others). It can be a convenient escape from the sometimes
tedious task of using the
psql
command line interface.
PgAccess was written in the Tcl/Tk scripting language; this increases its level of
portability, as it can be installed and run on any system that supports the Tcl/Tk scripting
language (including Linux/UNIX, Windows, and MacOS). As PgAccess is a client side
application, PostgreSQL is not required to be on the machine running PgAccess.