pgaccess1
A graphical postgresql client application
Usage
pgaccess [dbname]
Overview
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, 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 the |
•
|
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. |
•
|
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. |
Notes
PgAccess is written in Tcl/Tk. Your PostgreSQL installation needs to be built with Tcl support for PgAccess to be available.
Releases
4 releases since Debian 2.0 (Hamm); the text changed 2 times.