pgaccess provides a graphical interface for PostgreSQL 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.
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
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, for example,
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 and 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.