pgaccess [ dbname ]
The name of an existing database to access.
pgaccess provides a graphical interface for Postgres where you can manage your tables, edit them, define queries, sequences and functions.
Opens any database on a specified host at the specified port, username and password.
Saves preferences in ~/.pgaccessrc file.
For tables, pgaccess can:
Open multiple tables for viewing, max n records (configurable).
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 filter 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 Del 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 support, table aliasing.
For sequences, pgaccess can:
Define new instances.
Inspect existing instances.
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:
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:
Call user defined scripts.