Tables
- opening multiple tables for viewing, max. n records (changed by preferences
menu)
- column resizing, dragging the vertical grid line (better in table
space rather than in the table header)
- text wrap in cells - layout saved for every table
- import/export to external files (SDF,CSV)
- filter capabilities (enter filter like (price>3.14)
- sort order capabilities (enter manually the sort field(s))
- editing in place
- improved table generator assistant
- improved field editing
Queries
- define , edit and stores "user defined queries"
- store queries as views
- execution of queries with optional user input parameters ( select
* from invoices where year=[parameter "Year of selection"] )
- viewing of select type queries result
- query deleting and renaming
- visual query builder with drag & drop capabilities. For any of
you who had installed the Tcl/Tk plugin for Netscape Navigator, you can
see it at work clicking here
Sequences
- defines sequences, delete them and inspect them
Functions
- define, inspect and delete functions in SQL, plpgsql and pgtcl languages
Reports
- design and display simple reports from tables
- fields and labels, font changing, style and size
- saves and loads report description from database
- show report previews, sample postscript output file
Forms
- open user defined forms
- form design module available
- query widget available, controls bound to query results
- click here for a description of forms and
how they can be used
Scripts
- define, modify and call user defined scripts
Users
- define and modify user information
PgAccess API for developing small applications