---
name: "pgaccess"
section: "1"
platform: "linux"
package: "pgaccess"
version: "7.2.1-2woody8"
release: "Debian 3.0 (Woody)"
platforms: ["linux"]
url: "https://new.carta.tech/pgaccess"
---

# pgaccess(1)

a graphical PostgreSQL client application

## NAME

pgaccess - a graphical PostgreSQL client application

## SYNOPSIS

**pgaccess** \[ *dbname* \]

### OPTIONS

- *dbname*

  The name of an existing database to access.

## DESCRIPTION

**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 VACUUM \[**vacuum**(l)\].

- •

  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.

## NOTES

**PgAccess** is written in Tcl/Tk. Your PostgreSQL installation needs to be built with Tcl support for **PgAccess** to be available.