pgaccess(1)

NAME

pgaccess - a graphical PostgreSQL client application

SYNOPSIS

pgaccess [ dbname ]

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(l)].

•

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.