PGACCESS(1)

NAME
pgaccess - a graphical PostgreSQL client application

SYNOPSIS

pgaccess [ dbname ]

  OPTIONS

dbname
    The name of an existing database to access.

DESCRIPTION

PgAccess provides a graphical interface for PostgreSQL wherein you can manage your tables, edit them, define queries, sequences and functions.

PgAccess can:

•   Open any database on a specified host at the specified port, user name, and password.

•   Execute VACUUM [vacuum(7)].

•   Save preferences in the ~/.pgaccessrc file.

For tables, PgAccess can:

•   Open multiple tables for viewing, with a configurable number of rows shown.

•   Resize columns by dragging the vertical grid lines.

•   Wrap text in cells.

•   Dynamically adjust row height when editing.

•   Save table layout for every table.

•   Import/export to external files (SDF, CSV).

•   Use filter capabilities; enter filters like price > 3.14.

•   Specify sort order; enter manually the sort field(s).

•   Edit in place; double click the text you want to change.

•   Delete records; point to the record, press the Delete key.

•   Add new records; save new row with right-button click.

•   Create tables with an assistant.

•   Rename and delete (drop) tables.

•   Retrieve information on tables, including owner, field information, indexes.

For queries, PgAccess can:

•   Define, edit and store user-defined queries.

•   Save view layouts.

•   Store queries as views.

•   Execute with optional user input parameters, e.g.,

    select * from invoices where year=[parameter "Year of selection"]

•   View any select query result.

•   Run action queries (insert, update, delete).

•   Construct queries using a visual query builder with drag & drop support, table aliasing.

For sequences, PgAccess can:

•   Define new instances.

•   Inspect existing instances.

•   Delete.

For views, PgAccess can:

•   Define them by saving queries as views.

•   View them, with filtering and sorting capabilities.

•   Design new views.

•   Delete (drop) existing views.

For functions, PgAccess can:

•   Define.

•   Inspect.

•   Delete.

For reports, PgAccess can:

•   Generate simple reports from a table (beta stage).

•   Change font, size, and style of fields and labels.

•   Load and save reports from the database.

•   Preview tables, sample Postscript print.

For forms, PgAccess can:

•   Open user-defined forms.

•   Use a form design module.

•   Access record sets using a query widget.

For scripts, PgAccess can:

•   Define.

•   Modify.

•   Call user defined scripts.

NOTES

PgAccess is written in Tcl/Tk. Your PostgreSQL installation needs to be built with Tcl support for PgAccess to be available.