Unsupported versions: 7.2 / 7.1



pgaccess -- PostgreSQL graphical client


pgaccess [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 VACUUM.

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