man pgaccess () - a graphical client application for PostgreSQL

NAME

pgaccess - a graphical client application for PostgreSQL

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, 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.

NOTES

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