pgaccess [ dbname ]

dbname

The name of an existing database to access.

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 [(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.