 |
Index for
Section 1 |
|
 |
Alphabetical
listing for P |
|
 |
Bottom of
page |
|
PGACCESS(1)
NAME
pgaccess - a graphical PostgreSQL client application
SYNOPSIS
pgaccess [ dbname ]
OPTIONS
dbname
The name of an existing database to access.
DESCRIPTION
PgAccess provides a graphical interface for PostgreSQL wherein you can
manage your tables, edit them, define queries, sequences and functions.
PgAccess can:
o+ Open any database on a specified host at the specified port, user name,
and password.
o+ Execute VACUUM [vacuum(5)].
o+ Save preferences in the ~/.pgaccessrc file.
For tables, PgAccess can:
o+ Open multiple tables for viewing, with a configurable number of rows
shown.
o+ Resize columns by dragging the vertical grid lines.
o+ Wrap text in cells.
o+ Dynamically adjust row height when editing.
o+ Save table layout for every table.
o+ Import/export to external files (SDF, CSV).
o+ Use filter capabilities; enter filters like price > 3.14.
o+ Specify sort order; enter manually the sort field(s).
o+ Edit in place; double click the text you want to change.
o+ Delete records; point to the record, press the Delete key.
o+ Add new records; save new row with right-button click.
o+ Create tables with an assistant.
o+ Rename and delete (drop) tables.
o+ Retrieve information on tables, including owner, field information,
indexes.
For queries, PgAccess can:
o+ Define, edit and store user-defined queries.
o+ Save view layouts.
o+ Store queries as views.
o+ Execute with optional user input parameters, e.g.,
select * from invoices where year=[parameter "Year of selection"]
o+ View any select query result.
o+ Run action queries (insert, update, delete).
o+ Construct queries using a visual query builder with drag & drop support,
table aliasing.
For sequences, PgAccess can:
o+ Define new instances.
o+ Inspect existing instances.
o+ Delete.
For views, PgAccess can:
o+ Define them by saving queries as views.
o+ View them, with filtering and sorting capabilities.
o+ Design new views.
o+ Delete (drop) existing views.
For functions, PgAccess can:
o+ Define.
o+ Inspect.
o+ Delete.
For reports, PgAccess can:
o+ Generate simple reports from a table (beta stage).
o+ Change font, size, and style of fields and labels.
o+ Load and save reports from the database.
o+ Preview tables, sample Postscript print.
For forms, PgAccess can:
o+ Open user-defined forms.
o+ Use a form design module.
o+ Access record sets using a query widget.
For scripts, PgAccess can:
o+ Define.
o+ Modify.
o+ 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.
|
Index for
Section 1 |
|
|
Alphabetical
listing for P |
|
 |
Top of
page |
|