pgaccess - PostgreSQL graphical client


SYNOPSIS

       pgaccess [ dbname ]

   OPTIONS
       dbname The name of an existing database to access.


DESCRIPTION

       pgaccess  provides  a  graphical  interface  for  Postgres
       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 [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 Delete key.

       · Add new records; save new row with right-button click.

       · Create tables with an assistant.

       · Rename and delete (drop) tables.

         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.

       · 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.


       · 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 installa­
       tion needs to be built with Tcl support for pgaccess to be
       available.


Man(1) output converted with man2html