pgaccess Application pgaccess Postgres graphical interactive client 1999-08-03 pgaccess [ dbname ] dbname The name of an existing database to access. pgaccess provides a graphical interface for Postgres where you can manage your tables, edit them, define queries, sequences and functions. Another way of accessing Postgres through tcl is to use or . pgaccess can: Open any database on a specified host at the specified port, username and password. Execute . Save preferences in ~/.pgaccessrc file. For tables, pgaccess can: Open multiple tables for viewing, max n records (configurable). 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 filter 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 Del 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.