PgAccess

PgAccess . Graphical interface for the PostgreSQL database manager written by Constantin Teodorescu in the Tcl / Tk language . where you can manage the tables, edit them, define queries, sequences and functions.

Summary

[ hide ]

  • 1 Features
  • 2 Advantages
  • 3 Examples of codes in Pgaccess
  • 4 Source

characteristics

It allows the user to interact with PostgreSQL in a similar way to many PC database applications , with option menus and various graphical tools. This means that the user can avoid the command line for most tasks. PgAccess does not change the way postgreSQL works, it only makes it easier to use for those who are used to graphic interfaces.

The most interesting part of pgaccess is not the information exploitation part, since being written in Tcl / Tk consumes too much memory and is not capable of handling it efficiently. However, what makes this system really interesting are the possibilities that a graphical interface has to handle the creation of views.

Advantage

  • Pgaccess allows:
    • Open any database on a certain host, specifying that host, the port, the specified port, the usernameand password.
    • Run VACUUM.
    • Save preferences in the ~ / .pgaccessrc file.
  • With tables, Pgaccess allows:
    • Open multiple tables for viewing, with a maximum of n records (configurable).
    • Change the size of the columns by moving the vertical lines that form it.
    • Enter textin cells.
    • Dynamically adjust the height of the cell during editing.
    • Save a table format for each table.
    • Import / export to / from external files (SDF, CSV).
    • Specify the order; manually enter the fields by which to sort.
    • Create tables with a wizard.
    • Rename and delete tables.
    • Retrieve information about tables, including owner, field information, indexes.
  • With queries, Pgaccess allows:
    • Define, edit and store user defined queries.
    • Save view formats.
    • Store queries as views.
    • Run with optional input parameters entered by the user.
    • Display any result of a select query.
    • Execute action queries (insert, update, delete).
    • Define queries using a visual query constructor with drag & frop support, and table aliasing.
  • With sequences, Pgaccess allows:
    • Define new instances.
    • Inspect existing instances.
  • With views, Pgaccess allows:
    • Define them by saving queries as views.
    • View them, with possibilities for sorting and filtering.
    • Design new views.
    • Delete (drop) existing views.
  • With functions, Pgaccess allows:
    • Define them.
    • Inspect them.
    • Delete them.
  • With reports, Pgaccess allows:
    • 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, samples of postscript impressions.
  • With forms, Pgaccess allows:
    • Open user-defined forms.
    • Use a form design module.
    • Access recordsets using query widget.
  • With scripts, Pgaccess allows:
    • Define them.
    • Modify them.
    • Call user-defined scripts.

Pgaccess code examples

  • To call the program, type:

pgaccess.tcl

  • To create a file called “Pgaccess”:

pgaccess name “PgAccess”

pgaccess description “postgreSQL frontend”

pgaccess mini-icon “mini-pgaccess.xpm”

pgaccess group “Applications”

pgaccess exec “pgaccess.tcl &”

 

Leave a Comment