2000-12-30 pgaccess 1 Application pgaccess PostgreSQL graphical client pgaccess dbname dbname The name of an existing database to access. 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 . 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. Retrieve information on tables, including owner, field 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. 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.