PGACCESS (1)
Postgres graphical interactive client
SYNOPSIS
pgaccess [ dbname ]
dbname
The name of an existing database to access.
DESCRIPTION
pgaccess provides a graphical interface
for Postgres
where you
can manage your tables, edit them, define queries, sequences and
functions.
Another way of accessing Postgres
through tcl is to use
pgtclsh(1)
or
pgtksh(1).
pgaccess can:
\(bu
Opens any database on a specified host at the specified port,
username and password.
\(bu
\(bu
Saves preferences in ~/.pgaccessrc file.
For tables, pgaccess can:
\(bu
Open multiple tables for viewing, max n records (configurable).
\(bu
Resize columns by dragging the vertical grid lines.
\(bu
\(bu
Dynamically adjust row height when editing.
\(bu
Save table layout for every table.
\(bu
Import/export to external files (SDF,CSV).
\(bu
Use filter capabilities; enter filter like price>3.14.
\(bu
Specify sort order; enter manually the sort field(s).
\(bu
Edit in place; double click the text you want to change.
\(bu
Delete records; point to the record, press Del key.
\(bu
Add new records; save new row with right-button-click.
\(bu
Create tables with an assistant.
\(bu
Rename and delete (drop) tables.
\(bu
Retrieve information on tables, including owner, field information, indices.
For queries, pgaccess can:
\(bu
Define, edit and store user defined queries.
\(bu
\(bu
\(bu
Execute with optional user input parameters; e.g.
select * from invoices where year=[parameter "Year of selection"]
\(bu
View any select query result.
\(bu
Run action queries (insert, update, delete).
\(bu
Construct queries using a visual query builder
with drag & drop support, table aliasing.
For sequences, pgaccess can:
\(bu
\(bu
Inspect existing instances.
\(bu
For views, pgaccess can:
\(bu
Define them by saving queries as views.
\(bu
View them, with filtering and sorting capabilities.
\(bu
\(bu
Delete (drop) existing views.
For functions, pgaccess can:
\(bu
\(bu
\(bu
For reports, pgaccess can:
\(bu
Generate simple reports from a table (beta stage).
\(bu
Change font, size and style of fields and labels.
\(bu
Load and save reports from the database.
\(bu
Preview tables, sample postscript print.
For forms, pgaccess can:
\(bu
\(bu
Use a form design module.
\(bu
Access record sets using a query widget.
For scripts, pgaccess can:
\(bu
\(bu
\(bu
Call user defined scripts.
|