The OpenNET Project / Index page

[ новости /+++ | форум | теги | ]

Интерактивная система просмотра системных руководств (man-ов)

 ТемаНаборКатегория 
 
 [Cписок руководств | Печать]

pgaccess (1)
  • >> pgaccess (1) ( Разные man: Команды и прикладные программы пользовательского уровня )
  •  

    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(7)].
    *
    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.


     

    Index

    NAME
    SYNOPSIS
    OPTIONS
    DESCRIPTION
    NOTES


    Поиск по тексту MAN-ов: 




    Партнёры:
    PostgresPro
    Inferno Solutions
    Hosting by Hoster.ru
    Хостинг:

    Закладки на сайте
    Проследить за страницей
    Created 1996-2024 by Maxim Chirkov
    Добавить, Поддержать, Вебмастеру