PGACCESS(1) PostgreSQL Client Applications PGACCESS(1)NAMEpgaccess - PostgreSQL graphical client
SYNOPSISpgaccess [ dbname ]
OPTIONS
dbname The name of an existing database to access.
DESCRIPTIONpgaccess 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, 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 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,
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 sup‐
port, 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.
NOTESpgaccess is written in Tcl/Tk. Your PostgreSQL installation needs to be
built with Tcl support for pgaccess to be available.
Application 2000-12-30 PGACCESS(1)