---
name: "pgaccess"
section: "1x"
platform: "linux"
package: "pgaccess"
version: "1:0.98.8.20030520-1"
release: "Debian 3.1 (Sarge)"
platforms: ["linux"]
url: "https://new.carta.tech/pgaccess/1x"
---

# pgaccess(1x)

a graphical client application for PostgreSQL

## NAME

pgaccess - a graphical client application for PostgreSQL

## 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, reports and functions.

**PgAccess** can:

- Open any database on a specified host at the specified port,

  user name, and password.

- Execute VACUUM \[[**vacuum**(7)](/vacuum/7.md)\].

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