PgAccess provides a graphical interface for PostgreSQL wherein you can manage your tables, edit them, define queries, sequences and functions.
Open any database on a specified host at the specified port, user name, and password.
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 the 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, 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, 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.
PgAccess is written in Tcl/Tk. Your PostgreSQL installation needs to be built with Tcl support for PgAccess to be available.
After launching pgaccess and entering the name of the database I wanted to use pgaccess responded with an error to the effect that no one was listening on port 5432. However, postgres was listening on that port.
The dialog box had five text entry boxes. I erased the name of the server and the "local" from the first two boxes -- I left all five boxes empty, except for the box containing the name of the database I wanted to connect to. That worked.