Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   6284 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

PGACCESS(1)		PostgreSQL Client Applications		   PGACCESS(1)

NAME
       pgaccess - PostgreSQL graphical client

SYNOPSIS
       pgaccess [ dbname ]

   OPTIONS
       dbname The name of an existing database to access.

DESCRIPTION
       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,	 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 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 sup‐
	 port, 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.

Application			  2000-12-30			   PGACCESS(1)

                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 

Vote for polarhome