2000-12-30 pgaccess 1 Application pgaccess a graphical PostgreSQL client application pgaccess dbname dbname The name of an existing database to access. 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 . 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. 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. PgAccess is written in Tcl/Tk. Your PostgreSQL installation needs to be built with Tcl support for PgAccess to be available.