pgaccess - a graphical client application for PostgreSQL

pgaccess [ dbname ]

OPTIONS

PgAccess provides a graphical interface for PostgreSQL wherein you can manage your tables, edit them, define queries, sequences, reports 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.

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