pgaccess - PostgreSQL graphical client
SYNOPSIS
pgaccess [ dbname ]
OPTIONS
dbname The name of an existing database to access.
DESCRIPTION
pgaccess provides a graphical interface for Postgres
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, username, 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 Delete key.
· Add new records; save new row with right-button click.
· Create tables with an assistant.
· Rename and delete (drop) tables.
information, indices.
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.
· 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 installa
tion needs to be built with Tcl support for pgaccess to be
available.
Man(1) output converted with
man2html